Database Administration (MOSC)

MOSC Banner

delete old audit sys records

edited Feb 28, 2017 1:04AM in Database Administration (MOSC) 4 commentsAnswered

Dear All,

We use a audit_trail OS.

SQL> show parameter audit;

NAME             TYPEVALUE                                  

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

audit_file_dest  string  /data/app/11.2.0.4/adminora/admin/cmsp/adump
audit_sys_operations                                     boolean TRUE
audit_syslog_level                                            string
audit_trail      string  OS                                     

Show parameters query failed

Problem: OS log file keeps growing in size too fast...

Could you tell me how to keep records just for 5 days and delete all records beyond to 5 day??

Thank you all in advance.

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