--查看数据库锁，诊断锁的来源及类型
SELECT B.OWNER, B.OBJECT_NAME, L.SESSION_ID, L.LOCKED_MODE
FROM V$LOCKED_OBJECT L, DBA_OBJECTS B
WHERE B.OBJECT_ID = L.OBJECT_ID;
--找出数据库的 serial#,以备杀死
SELECT T2.USERNAME, T2.SID, T2.SERIAL#, T2.LOGON_TIME
FROM V$LOCKED_OBJECT T1, V$SESSION T2
WHERE T1.SESSION_ID = T2.SID
ORDER BY T2.LOGON_TIME;
--杀死该 session
ALTER SYSTEM KILL SESSION '712,38739'
Copyright © 2015 Powered by MWeb, Theme used GitHub CSS.