I would like to know how to limit the number of files of audit generated in the audit directory, I have an Oracle 12c database. The AUDIT_TRAIL parameter is equal to NONE, however it continues to generate .aud files, I would like to know how to limit the number of files or if I can prevent them from being generated completely. Thank you


Connections as sysdba or as sysoper, also startup and shutdown events are always audited, whether AUDIT_TRAIL is set or not.


Oracle has a purge job that you can run to limit the number of days to keep audit records.So you can have the audit records automatically purged. As Eduard Okhvat stated, the default is to audit certain events, whether you configure it or not. You probably want to go through all of the audit events and see which ones are relevant for your organization.

About Scheduling an Automatic Purge Job

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.