Db Lock 및 세션킬 조회

SELECT DISTINCT

       X.SESSION_ID,

       A.SERIAL#,

       D.OBJECT_NAME,

       A.MACHINE,

       A.TERMINAL,

       A.PROGRAM,

       A.LOGON_TIME,

       'ALTER SYSTEM KILL SESSION ''' || A.SID || ', ' || A.SERIAL# || ''';' AS SCRIPT

  FROM GV$LOCKED_OBJECT X, GV$SESSION A, DBA_OBJECTS D

WHERE X.SESSION_ID = A.SID

   AND X.OBJECT_ID = D.OBJECT_ID

ORDER BY LOGON_TIME;