How to stop the Gather Stats Job in Oracle?
Answer:
-- For Oracle 10g (10.2.0.4) or higher
( Log in as SYS )
exec dbms_scheduler.disable('GATHER_STATS_JOB',TRUE);
-- For Oracle 11g (11.1.0.7) or higher
( Log in as SYS )
exec dbms_auto_task_admin.disable('auto optimizer stats collection',null,null);
[Reference]
http://docs.oracle.com/cd/E24628_01/install.121/e22624/appdx_about_emprereqkit.htm
文章標籤
全站熱搜
