SELECT S.SID, S.BLOCKING_SESSION , A.SQL_TEXT, A.ADDRESS, L.CTIME
FROM V$LOCK L, V$SESSION S, V$SQLAREA A
WHERE L.SID = S.SID
AND S.SQL_ADDRESS = A.ADDRESS
AND L.TYPE = 'TX';
![](http://hi.csdn.net/attachment/201109/8/0_1315451968UZJm.gif)
SELECT S.SID, S.BLOCKING_SESSION , A.SQL_TEXT, A.ADDRESS, L.CTIME
FROM V$LOCK L, V$SESSION S, V$SQLAREA A
WHERE L.SID = S.SID
AND S.SQL_ADDRESS = A.ADDRESS
AND L.TYPE = 'TX';