ora-00031:session marked for kill处理oracle中杀不掉的锁
Kill排他锁:
如果是Kill Lock的话,可以参考下边的方法:
SELECT OBJECT_NAME AS 对象名称,S.SID,S.SERIAL#,P.SPID AS 系统截程号
FROM V$LOCKED_OBJECT L , DBA_OBJECTS O , V$SESSION S , V$PROCESS P
WHERE L.OBJECT_ID=O.OBJECT_ID A
原创
2015-11-12 11:39:56 ·
510 阅读 ·
0 评论