|
[oracle-l]
||
[Date Prev]
[07-2006 Date Index]
[Date Next]
||
[Thread Prev]
[07-2006 Thread Index]
[Thread Next]
RE: gather_dictionary_stats runs automatically - how?
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: <nigel@xxxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 Jul 2006 10:43:29 +0100
Cheers Nigel,
I had sussed that out to be honest. What I don't understand is how why
you do not see the frequency of the job when querying the scheduler
SELECT start_date,end_date,next_run_date,last_start_date FROM
DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'GATHER_STATS_JOB'
START_DATE END_DATE NEXT_RUN_DATE LAST_START_DATE
---------- ---------- -------------------- --------------------
04-JUL-06 22.00.00.8
56571 +01:00
John
This job is created, and enabled automatically when you create a new
Oracle database under Oracle Database 10g. To see this job, use the
DBA_SCHEDULER_JOBS view
Disable thus:
exec dbms_scheduler.disable('GATHER_STATS_JOB');
See http://www.dbazine.com/olc/olc-articles/freeman2,
http://www.oracle.com/technology/pub/articles/10gdba/week20_10gdba.html,
etc...
--
http://www.freelists.org/webpage/oracle-l
|
|
