How to turn off audit functionality in Oracle

The Oracle 11g default installation database starts the audit feature, resulting in increased Oracle cumulative sys.aud$ table and associated index data volumes;

If the table space is full, the ora-1654:unable to extend index SYS will be reported in the alert log .... Error.

If the audit function is not used, it is recommended that the audit be closed.

Processing process:

1, with the Oracle user login to the database server, execute:

Sqlplus/as SYSDBA

2, cancel audit, set initialization parameter audit_trail to none

Alter system set Audit_trail=none Scope=spfile;

3, and then restart the database.

Shutdown immediate;

Sqlplus/as SYSDBA

Startup

4, delete the authority data, Oracle users log on to the database server:

Sqlplus/as SYSDBA

TRUNCATE TABLE SYS. aud$;

This article is from "Richard's notes-accumulate micro Cheng" blog, please be sure to keep this source http://zxf261.blog.51cto.com/701797/762048

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/