網上些解決方法，就是關閉審計，之前也有同事推薦這樣，下面就是關閉審計的步驟，
VALUE=https://www.cnblogs.com/chxmtl/p/DB即審計開啟，改成FALSE即可，
SQL> show parameter audit_trail;NAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_trail string DBSQL> alter system set audit_trail=FALSE scope=spfile;System altered.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 776646656 bytesFixed Size 2257272 bytesVariable Size 511708808 bytesDatabase Buffers 255852544 bytesRedo Buffers 6828032 bytesDatabase mounted.Database opened.SQL> show parameter audit_trail;NAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_trail string FALSESQL>
有時還需要將另一個引數修改
audit_sys_operations 如果這個引數值不是false，則需要修改成false
alter system set audit_sys_operations=FALSE scope=spfile;
SQL> show parameter audit; NAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_file_dest string /u01/app/oracle/admin/oadb/adu mpaudit_sys_operations boolean FALSEaudit_syslog_level stringaudit_trail string FALSESQL>
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/36951.html
標籤：Oracle