sys.aud$ Problems
Hello everybody,
last week we moved our database from 10gR1 on a Solaris10 Server to 11gR2 on a Windows2008 Server.
To be compliant I run the same audit commands as on the old Server.
The commands are:
alter system set audit_trail=DB scope=spfile;
audit session;
audit all by USR;
audit insert table, delete table, update table by USR;
last week we moved our database from 10gR1 on a Solaris10 Server to 11gR2 on a Windows2008 Server.
To be compliant I run the same audit commands as on the old Server.
The commands are:
alter system set audit_trail=DB scope=spfile;
audit session;
audit all by USR;
audit insert table, delete table, update table by USR;
And now I have a big problem with the sys.aud$ table.
On the old server we had about 4000 entries a day, but now on 11gR1 we have about 4000 every hour.
I tried to stop some audit options with:
noaudit session;
0