How to turn off audit in oracle

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.

How to turn off audit in Oracle

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!