oracle数据库system表空间增长过大的问题,
网上些解决方法,就是关闭审计,之前也有同事推荐这样,下面就是关闭审计的步骤。
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>
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。