chk_userlogin.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 *