星期三, 5月 26, 2010

oracle 10g 關閉 AWR GATHER_STATS_JOB




AWR自動收集可能會發生enqueue lock的情形導致db hang
---
1.爲了讓gather_stats_job工作正常 , 必須確定statistics_level初始化參數設置爲typical
show parameter statistics_level
2.已經  exec DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');
3.確認是否disabled :  
select job_name,job_action,enabled from DBA_SCHEDULER_JOBS;
----------------------------------
可定期 cronjob手動做  "Manual Statistics Gathering"  , For a description of the automatic and manual processes, see "Automatic Statistics Gathering" or "Manual Statistics Gathering".

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...