|
[oracle-l]
||
[Date Prev]
[07-2006 Date Index]
[Date Next]
||
[Thread Prev]
[07-2006 Thread Index]
[Thread Next]
gather_dictionary_stats runs automatically - how?
- From: John Hallas <john.hallas@xxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 05 Jul 2006 08:55:01 +0100
I am struggling to see what controls a gather_dictionary_stats job
that runs on all my 10.2.0.2 databases.
I have never knowingly submitted the job and yet SELECT
start_date,end_date,next_run_date,last_start_date FROM
DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'GATHER_STATS_JOB'
shows it running on each database. It never has a next date set and
always appears to have run the previous day. Looking at the scheduler
via Grid I do not se a job set up either, nor in dbms_jobs.
Believe me, I have searched for the answer to this and come across a few
useful bits of info but not the reason as to what is controlling the job
John
|
|
