This content has been marked as final. Show 9 replies
Harvey wrote:DBMS_LOGMNR can reveal all DML activity.
Is it possible to audit Commit and Rollback.
Database version is 22.214.171.124
Under AUDIT_ACTIONS I can see two entries for Commit and Rollback
let me know if this can be done.
Reason I want to do this is, user insert records from session and then close session without commiting and data is lost. But there is no evidence as if they did commit the transaction or not.
DBMS_LOGMNR can reveal all DML activity.However Harvey should note,
DBMS_LOGMNR does not distinguish explicit and implicit commits and rollbacks.
It reconstructs transaction endings without a knowledge how it has been done.
If you see Rollback in LM, it does not mean that user/app explicitly issued it.
Same with Commit.
Hi, I have the same problem. For an update with rollback, I see the same entries in the aud$, like for an update with a commit.
For both I have an SCN and a TRANSACTIONID. I have to know, if there was a COMMIT or a ROLLBACK afterwords.
You say query audit table with appropriate parameters. Could you please describe it more. Thanks