/* 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#;
相关文章
- 02-06捕获长时间不提交的SQL语句
- 02-06捕获长时间不提交的SQL语句
- 02-06PB中获取datawindow提交的sql语句
- 02-06ORACLE中能否找到未提交事务的SQL语句
- 02-06ahjesus 捕获entity framework生成的sql语句
- 02-06SQL Server捕获发生The query processor ran out of internal resources and could not produce a query plan...错误的SQL语句
- 02-06当多条SQL语句添加到数据库中,可以采取基于事物的方法进行提交到数据库中
- 02-06事务控制语句,begin,rollback,savepoint,隐式提交的SQL语句
- 02-06MySQL的SQL语句 -事务性语句和锁定语句(2)- 导致隐式提交的语句