ORACLE 锁语句管理脚本

SELECT A_S.OWNER,
       A_S.OBJECT_NAME,
       A_S.OBJECT_TYPE,
       VN.SID,
       VN.SERIAL#,
       VS.SPID"OS_PID",
       VN.PROCESS"CLIENT_PID",
       VN.USERNAME,
       VN.OSUSER,
       VN.MACHINE"HOSTNAME",
       VN.TERMINAL,
       VN.PROGRAM,
       VA.SQL_TEXT,
       TO_CHAR(VN.LOGON_TIME, 'YYYY-MM-DD HH24:MI:SS') "LOGIN_TIME",
       'alter system kill session ''' || VN.SID || ',' || VN.SERIAL# ||
       ''';' "ORACKE_KILL",
       'kill -9 ' || VS.SPID"OS_KILL"
  FROM ALL_OBJECTS     A_S,
       V$LOCKED_OBJECT V_T,
       V$SESSION       VN,
       V$PROCESS       VS,
       V$SQLAREA       VA
 WHERE A_S.OBJECT_ID = V_T.OBJECT_ID AND V_T.SESSION_ID = VN.SID AND
       VS.ADDR = VN.PADDR AND VN.USERNAME NOT IN ('SYSMAN', 'SYS') AND
       VN.SQL_HASH_VALUE = VA.HASH_VALUE