Oracle 세션 조회·강제 종료

세션 조회

SELECT * FROM V$SESSION;

SELECT *
  FROM V$SESSION A, V$PROCESS B
 WHERE A.PADDR = B.ADDR
   AND A.USERNAME = '프로세스아이디';

SELECT USERNAME, PROGRAM FROM V$SESSION;

강제 종료

ALTER SYSTEM KILL SESSION '세션번호,시리얼번호';

KILL 스크립트 생성

SELECT A.LOGON_TIME, A.SID, A.SERIAL#, A.USERNAME, A.SCHEMANAME,
       A.MACHINE, A.TERMINAL, A.PROGRAM, A.MODULE, A.CLIENT_INFO,
       'ALTER SYSTEM KILL SESSION '''||A.SID||','||A.SERIAL#||''';' AS KILLSCRIPT
  FROM V$SESSION A
 ORDER BY A.LOGON_TIME;