Hello,
Oracle Linux 11.2.0.4
How to get SQL text which caused a transaction?
Especially interested in situation where user did some DMLs and then some queries. No commit or rollback was executed. So, user's session remains inactive but with active transaction in v$transaction. By joining v$session and v$transactions I can see that this session has an active transaction. But how to find which DML initiated this transaction?
Solution with "PREV_SQL_ID" doesnt work as in this case it shows last statement (which is not DML)
Regards, Randjar