How To Disable/Enable Gather Stats Job

You can disable the automatic gather statistics with (this disable the job);

exec dbms_scheduler.disable(‘GATHER_STATS_JOB’);

We can enable the job with;

exec dbms_scheduler.enable(‘GATHER_STATS_JOB’);

We can see the status of the automatic collection of statistics with the following query

SELECT  STATE  

FROM DBA_SCHEDULER_JOBS 

WHERE JOB_NAME = ‘GATHER_STATS_JOB’;

 

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s