Oracle關閉審計功能

標籤：關閉審計功能

[[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, 2011, 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；//查看審計功能是否開啟，DB是開啟的意思

NAME     TYPE VALUE

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

audit_trail     string DB

SQL> alter system set audit_trail=FALSE scope=spfile;  //關閉審計功能

System altered.

SQL> show parameter audit_trail

NAME     TYPE VALUE

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

audit_trail     string DB

SQL> 

SQL> shutdown immediate;  //要重啟才會生效

SQL> startup;

刪除資料表空間中的審計日誌

truncate table sys.Aud$

Oracle關閉審計功能