Database Administration (MOSC)

MOSC Banner

Sys Auditing View Cleanup

edited Mar 26, 2014 9:48AM in Database Administration (MOSC) 17 commentsAnswered ✓
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center