Audit Commit and Rollback - Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Audit Commit and Rollback - Help

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    8
    Hello,

    I'm using audit and I would like to see if my DML orders are committed or rollbacked.

    For the moment I just can see (from dba_audit_trail) :

    USERID TIMEST Action name PRIV_USED OBN
    -------------------- ------------ --------------- ----
    SCOTT 05-jun 09:55 LOGON CREATE SESSION
    SCOTT 05-jun 09:55 SELECT EMP
    SCOTT 05-jun 09:55 INSERT EMP

    But my commits or rollbacks do not appear.

    Do you know how I can see that ?

    Thanks for your help.
    Thg

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    I guess oracle does not audit commit and rollback operation

    i hope i am not wrong, friends

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Sep 2001
    Posts
    200
    You are damn right. Oracle does not audit commits or rollbacks. I guess one audit user access and user DDL. Why don't you query the table to find out your commits or rollbacks?
    Life is what is happening today while you were planning tomorrow.

  4. #4
    Join Date
    Mar 2002
    Posts
    8

    Unhappy

    Querying tables should be too heavy in my OLTP system.
    I would have liked audit contains this feature. (
    Thanks.
    TomG

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width