捕獲長時間不送出的SQL語句

/* Formatted on 2014/5/19 17:16:16 (QP5 v5.240.12305.39476) */

SELECT s.sid, s.serial#, ss.sql_text

FROM v$session s, v$sql

ss

WHERE s.prev_hash_value != 0

AND

s.sql_hash_value = 0

AND s.prev_hash_value =

ss.hash_value

AND (ss.sql_text LIKE ‘%insert%‘)

ORDER BY

s.sid, s.serial#;