Database Security Products (MOSC)

MOSC Banner

Purge older v$xml_audit_trail records

edited Sep 29, 2016 8:22AM in Database Security Products (MOSC) 2 commentsAnswered ✓

How do I purge (older) records from v$xml_audit_trail records? We regularly remove the associated XML files from the OS but the view still has millions of records:

select count(*) from v$xml_audit_trail;

2,917,998

SQL> show parameter audit_trail

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

audit_trail                          string      XML, EXTENDED

SQL> show parameter audit_file_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

audit_file_dest                      string      /home/oracle/admin/fsprd2/adump

> ls -1 /home/oracle/admin/fsprd2/adump/*.xml | wc -l

8085

Tagged:

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