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
06-05-2002, 10:07 AM
anandkl
I guess oracle does not audit commit and rollback operation
i hope i am not wrong, friends
regards
anandkl
06-05-2002, 10:40 AM
ndisang
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?
06-05-2002, 12:00 PM
TomG
Querying tables should be too heavy in my OLTP system.
I would have liked audit contains this feature. :o(
Thanks.