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".