Auditing in Oracle with aud$, system tablespace fragmentation issues?
Posted on 2004-10-06
When auditing in Oracle using aud$ (audit_trail = db), I am concerned about system tablespace fragmentation. There will be a few thousand $aud entries per day on the average database (with pretty limited auditing).
I will be:
Offloading into text files or exporting the contents of the $aud table regularly.
Truncating weekly or nightly.
I will follow Oracle's strict instructions to not move $aud into another tablespace despite the recommendations of a an Oracle author. I'll do audit_trail=os before doing that.