SELECT username
     , TO_CHAR(logon_time, 'yyyy/mm/dd hh24:mi:ss') logon_time
     , status
     , 'alter system kill session ''' || sid || ',' || serial# || ''';' kill_session
  FROM v$session
 WHERE username IS NOT NULL
ORDER BY logon_time ASC;


SELECT a.username
     , a.status
     , a.logon_time
     , 'kill -9 ' || b.spid kill_process
  FROM v$session a, v$process b
 WHERE a.paddr = b.addr
   AND a.username IS NOT NULL
ORDER BY a.logon_time;

이 게시물을..