Sys Auditing View Cleanup
I have recently setup sys user auditing on my environments so that I can create monitoring reports. In order to get this set up I have made the following changes to my init.ora parameters:
audit_sys_operations TRUE
audit_trail XML,
EXTENDED
The issue I am running into now is that the SYS.V_$XML_AUDIT_TRAIL view and SYS.AUD$ table are growing at a rapid pace. I realize that I need to create a job to clean up the records/XML files that are displayed in this view and table, however I have no idea where that is.
1