Query to get rolled back statement

Query to get rolled back statement:

SELECT x.SQL_TEXT
FROM V$SQL x,v$session_longops y,v$session z

where x.SQL_ID=y.SQL_ID and z.SQL_ADDRESS=y.SQL_ADDRESS and z.SQL_HASH_VALUE=y.SQL_HASH_VALUE;

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply