9 Replies Latest reply: May 23, 2012 9:45 AM by 871018 RSS

    Can we audit commit and rollback

    Harvey
      Hi,

      Is it possible to audit Commit and Rollback.

      Database version is 11.2.0.2

      Under AUDIT_ACTIONS I can see two entries for Commit and Rollback
      44 COMMIT
      45 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.

      Thank you.
      --Harvey