RE: gather_dictionary_stats runs automatically

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Wed, 5 Jul 2006 10:43:29 +0100
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F63034BDDCA@UKWMXM04>

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 Received on Wed Jul 05 2006 - 04:43:29 CDT

RE: gather_dictionary_stats runs automatically - how?