Dear All,
Oracle Database 11g R2 11.2.0.1 SE1
Currently in the development database, I have enabled regular auditing on SELECT, INSERT, UPDATE, DELETE for around 10 tables (most accessed) out of 140
The aud$ table growth rate is around 100 records per minute (average), and the DB is accessed by 20 people simultaneously.
I have also scheduled the DELETE job for aud$ table every night at 12:00. (Delete rule --> SYSDATE - 2)
Does this auditing degrade the performance of the database when I implement the same to Production?
If it all, I want to stop auditing in any case, does the bug (Bug 1257564: noaudit does not turn off auditing of database.) avoid me in doing so, since I did not find the fixed release for the bug in oracle support.
Kindly guide with this regard.