Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gather_stats_job not found 11.1.0.7

emersoklJun 11 2009 — edited Jun 11 2009

I installed 11.1.0.7 on window 2008 and am trying to determine whether the gather stats job is actually running. Tables stats are available so I am guesising it is running but I can't find it.

SELECT *
FROM DBA_SCHEDULER_JOBS
WHERE JOB_NAME = 'GATHER_STATS_JOB';

We are a PeopleSoft shop and the tunning doc supplied by Oracle suggest you disable this job so temp tables do not get stats generated.

Does anyone know why I can't find this job? Has the job been renamed?

Thanks,
Kathie

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2009

Added on Jun 11 2009

#general-database-discussions

3 comments

677 views