Scripts chk_user_login.sql May 10, 2017 mrculp Leave a comment Set Define on set numwidth 16 col username format a15 col machine format a30 col sysdate format a21 Select count(*),username,machine from gv$session where username = upper('&1') Group by username,machine / set define off