Home > Database > Oracle > body text

How to turn off audit in oracle

WBOY
Release: 2022-05-10 16:20:32
Original
3046 people have browsed it

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.

How to turn off audit in oracle

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;
Copy after login

3,Then restart the database.

shutdown immediate;
sqlplus / as sysdba
startup;
Copy after login

4. Delete the signature data, and the oracle user logs in to the database server :

sqlplus / as sysdba
truncate table SYS.AUD$;
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template