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