Archiving the DBA Audit Trail
I doubt it's breaking news that:
A moderate amount of auditing configured in your Production database AND Retaining the audit trail for longer than a couple of weeks
=
Large AUD$/dba_audit_trail AND ever increasing impact on performance as the trail gets larger and larger
The thought occurred to me that I could copy audit information older than x days into an archive table, thus keeping the audit trail itself nice and petite but keep the trail data for reference if required/desirable.
The archive table would be partitioned by day and, given that it's on an Exadata machine, I'd probably use HCC on it, just because it's cool.
I don't plan on using the more advanced audit options from Oracle - I don't feel that's needed and I can accomplish what I want easily enough this way.
UNLESS...
The fact that I can't seem to find much evidence others have implemented this gives me a moment's pause. Pretty much every search seems to point me to the advanced options rather than a 'How To' article written by a fellow DBA who had the same idea much earlier than I. I'd assume that Oracle has some pretty awesome SEO experts, but I'd expect to see something...
Am I missing something? Is there a reason why this wouldn't work that is so blindingly obvious that I'm a mindless cretin for not spotting it. Honestly, I did attempt to consult the awesome manual before asking this...
Mark