Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to stop generating audit trace files for sys user??

User_KYWTCJun 4 2020 — edited Jun 13 2020

Hi Team

My current environment is 12.1.0.2 and we are in mixed mode auditing.

We could see audit trace files are still getting generated even after making audit_sys_operations=false . Is there anyway to stop generating these trace files?

NAME TYPE VALUE

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

audit_sys_operations boolean FALSE

Audit_file_dest

=============

-rw-r-----. 1 oracle oinstall 2.1K Jun 4 13:41 REVSND00_ora_15642_20200604134058036954143795.aud

-rw-r-----. 1 oracle oinstall 724 Jun 4 13:41 REVSND00_ora_15687_20200604134125979544143795.aud

-rw-r-----. 1 oracle oinstall 728 Jun 4 13:41 REVSND00_ora_15750_20200604134126049767143795.aud

-rw-r-----. 1 oracle oinstall 731 Jun 4 13:41 REVSND00_ora_15767_20200604134130211577143795.aud

This post has been answered by User_KYWTC on Jun 13 2020

Jump to Answer

Added on Jun 4 2020

#database-security, #database-security-general

3 comments

1,656 views