[Weblog Reference] Disable Automatic Statistics Gathering Job

I found someone used the following procedure call to disable the automatic statistics gathering job to gather the user (not sys/system) tables by accident.

exec DBMS_STATS.SET_PARAM( ' AUTOSTATS_TARGET ' , ' ORACLE ' );

For the reason that we may need to disable this job, please refer to this article for details. 

Briefly speaking, the automatic statistics gathering job may gather the table statistics at the wrong time which hence most likely result in the wrong SQL execution plans. Keep an eye on this. 

转载于:https://www.cnblogs.com/fangwenyu/archive/2011/04/15/2016826.html