摘要： 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 <> 010 AND H.TYPE = W.TYPE11 AND H.ID1 = W.ID112 AND H 阅读全文