网上些解决方法,就是关闭审计,之前也有同事推荐这样,下面就是关闭审计的步骤。
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>
有时还需要将另一个参数修改
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 mp audit_sys_operations boolean false audit_syslog_level string audit_trail string false sql>
如对本文有疑问, 点击进行留言回复!!
Oracle GoldenGate(基于日志的结构化数据复制软件使用)
创建线程的两个方法(Oracle官网说两种,所以我们就别说什么三种四种了)
网友评论