chk_user_login.sql


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

Leave a Reply

Your email address will not be published. Required fields are marked *