网上些解决方法,就是关闭审计,之前也有同事推荐这样,下面就是关闭审计的步骤。

VALUE=DB即审计开启,改成FALSE即可。

SQL> show parameter audit_trail;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
audit_trail                 string     DB
SQL> alter system set audit_trail=FALSE scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  776646656 bytes
Fixed Size            2257272 bytes
Variable Size          511708808 bytes
Database Buffers      255852544 bytes
Redo Buffers            6828032 bytes
Database mounted.
Database opened.
SQL> show parameter audit_trail;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
audit_trail                 string     FALSE
SQL> 
01-03 09:13