--查询被锁的表和相关会话信息
SELECT OBJECT_NAME,
SESSION_ID SID,
MACHINE,
VS.MODULE,
'ALTER SYSTEM KILL SESSION ''' || SESSION_ID || ',' ||
SERIAL# || ''';' KILL_SESSION,
VS.STATUS,
VS.ACTION,
SERIAL#,
ORACLE_USERNAME,
OS_USER_NAME
FROM V$LOCKED_OBJECT VO, V$SESSION VS, ALL_OBJECTS AO
WHERE VO.SESSION_ID = VS.SID
AND AO.OBJECT_ID = VO.OBJECT_ID
AND NVL(VS.ACTION, ' ') <> 'Service Management'
ORDER BY OBJECT_NAME, MACHINE, VS.MODULE;
解锁kill的sql
alter system kill session 'sid, serial#'