Home > 10g > ALL ABOUT GATHER_STATS_JOB in Oracle 11g and Oracle 10g.

ALL ABOUT GATHER_STATS_JOB in Oracle 11g and Oracle 10g.

November 9, 2013

Recently i got an opportunity to work on GATHER_STATS_JOB as a part of upgrading my database from 10.2.0.2 to 11.2.0.3.4. I thought of sharing my knowledge which i got.

1) How to disable or enable the job?

In 10g, by default it will be enabled where as in oracle 11g, it is disabled. As per our requirement we may need to enable or disable this job.  Following is the method to find weather it is enabled or disable.

 

Advertisements
Categories: 10g
%d bloggers like this: