In Oracle, you can use the alter statement and the "audit_trail" parameter to turn off the audit function. The "audit_trail" parameter can control the opening and disabling of auditing. The syntax is "alter system set audit_trail=FALSE scope=spfile".
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
1. Turn off the audit function
1. Check whether the audit function is turned on?
su – oracle sqlplus “/as sysdba” SQL> show parameter audit_trail NAME TYPE VALUE audit_trail string DB
Explanation: The VALUE value is DB, and the surface audit function is turned on
2. Turn off the audit function of Oracle
SQL> alter system set audit_trail=FALSE scope=spfile; System altered.
3. Restart the database
SQL> shutdown immediate; SQL> startup;
4. Verify whether the audit has been closed
SQL> show parameter audit_trail NAME TYPE VALUE audit_trail string FALSE
Description: The VALUE value is FALSE, and the surface audit function is closed
2. Delete the audit log
When it has been When a log is formed, the records in it can be deleted. Currently, they are deleted directly without affecting the database.
Query the current log information: select * FROM SYS.AUD$;
Delete existing audit information: DELETE FROM SYS.AUD$;
Or quickly delete the table Information: truncate table SYS.AUD$;
Recommended tutorial: "Oracle Video Tutorial"
The above is the detailed content of How to turn off auditing in oracle. For more information, please follow other related articles on the PHP Chinese website!