Oracle死锁解决办法

处理步骤：

--查看哪些表被锁住
SELECT B.OWNER, B.OBJECT_NAME, A.SESSION_ID, A.LOCKED_MODE
  FROM V$LOCKED_OBJECT A, DBA_OBJECTS B
 WHERE B.OBJECT_ID = A.OBJECT_ID;

--查处引起死锁的会话寻找SID
SELECT B.USERNAME, B.SID, B.SERIAL#, LOGON_TIME
  FROM V$LOCKED_OBJECT A, V$SESSION B
 WHERE A.SESSION_ID = B.SID
 ORDER BY B.LOGON_TIME;

--查出SID和SERIAL#
SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID='刚才查到的SID';
--杀死进程
ALTER SYSTEM KILL SESSION '查出的SID,查出的SERIAL#';

其中，表锁住和SID查询可合并成下面一个SQL，后面继续执行杀死进程语句
SELECT B.OWNER,V.USERNAME,V.SID,V.SERIAL#,B.OBJECT_NAME, V.LOGON_TIME, A.LOCKED_MODE
  FROM V$LOCKED_OBJECT A, DBA_OBJECTS B，V$SESSION V
 WHERE B.OBJECT_ID = A.OBJECT_ID AND A.SESSION_ID = V.SID ORDER BY V.LOGON_TIME;