Oracle 数据库 Blocking Locks 死锁查询 SQL

 1 SELECT /*+ RULE */
 2  distinct B.USERNAME,
 3  A.USERNAME,
 4  H.SID SESSION_ID, --需要killed
 5  W.SID SESSION_ID
 6  FROM V$SESSION B, V$ACCESS O, V$LOCK H, V$LOCK W, V$SESSION A
 7  WHERE H.LMODE <> 0
 8   AND H.LMODE <> 1
 9   AND W.REQUEST <> 0
10   AND H.TYPE = W.TYPE
11   AND H.ID1 = W.ID1
12   AND H.ID2 = W.ID2
13   AND B.SID = H.SID
14   AND W.SID = A.SID
15   AND (O.SID = W.SID OR O.SID = H.SID)
16   AND O.OWNER <> 'SYS';

 

转载请标明出处
http://www.cnblogs.com/QQ308368388/archive/2013/03/05/Oracle%E6%95%B0%E6%8D%AE%E5%BA%93Blocking_Locks%E6%AD%BB%E9%94%81.html

转载于:https://www.cnblogs.com/QQ308368388/archive/2013/03/05/Oracle%e6%95%b0%e6%8d%ae%e5%ba%93Blocking_Locks%e6%ad%bb%e9%94%81.html