查看表是谁锁和解锁

--查询被锁的表和相关会话信息
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#'