ORACLE一条SQL查等待语句

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';