Folks,
I just started the auditing at the database level i.e. audit_trail=db_extended for my 11.2.0.3.
Basically I am auditing, DDL statements , by 2 db users in the database.
It is working, however the information in the dba_audit_trail view is changing (The view dba_audit_trail shows only few rows).
I understand that that view, dba_audit_trail is based off the AUD$ table.
So i am thinking there is some sort of maintenance job, set by default, that maintains the amount of data in the AUD$ table.
My goal is to capture the data in the view dba_audit_trail for a longer duration, say for the last 15 days , that probably trickles down the AUD$ table ?
It seems there is some maintenance job etc, that keeps deleting data from AUD$ . --- This might be an Oracle default maintenance job ?
Thanks,
Ashish