Oracle Shutdown Audit Feature

[Email protected] ~]# su-oracle

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.3.0 Production on Wed Jul 12 09:54:57 2017

Copyright (c) 1982, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the partitioning, OLAP, Data Mining and Real application testing options

Sql> Show parameter audit_trail;//check whether the audit function is on, db is open meaning

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Audit_trail string DB

Sql> alter system set AUDIT_TRAIL=FALSE Scope=spfile; Turn off audit function

System altered.

Sql> Show Parameter Audit_trail

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Audit_trail string DB

Sql>

sql> shutdown immediate; Restart is not effective

Sql> startup;

To delete an audit log in a tablespace

TRUNCATE TABLE sys. aud$

Oracle shuts down auditing capabilities