使用SQL查看是否锁表:
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;
在查询出的结果里找到 sid和serial#:
干掉即可
alter system kill session '1155,39095';