Close method: 1. Use "alter system set audit_trail=none scope=spfile" to set "audit_trail" to none; 2. Use "shutdown immediate" and "startup" to restart the database.
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
The default installation database of Oracle 11g starts the audit function, which causes Oracle to continuously accumulate the sys.aud$ table and related index data and increase the amount of data;
If the table space becomes full, an ORA-1654: unable to extend index SYS.... error will be reported in the alert log.
If you do not use the audit function, it is recommended to turn off auditing.
Processing process:
1. Log in to the database server as the oracle user and execute:
sqlplus / as sysdba
2.Cancel audit , set the initialization parameter audit_trail to NONE
alter system set audit_trail=none scope=spfile;
3,Then restart the database.
shutdown immediate; sqlplus / as sysdba startup;
4. Delete the signature data, and the oracle user logs in to the database server ：
sqlplus / as sysdba truncate table SYS.AUD$;
Extended knowledge:
Delete audit log
When a log has been formed, the records in it can be deleted. Currently, it is 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 table information: truncate table SYS.AUD$;
Recommended tutorial: "Oracle Video Tutorial》
The above is the detailed content of How to turn off audit in oracle. For more information, please follow other related articles on the PHP Chinese website!