Re: gather_dictionary_stats runs automatically - how?
- From: "Domingo Diaz Saenz" <domingo.diazs@xxxxxxxxx>
- To: John.Hallas@xxxxxxxxxxxxxxxxx
- Date: Wed, 5 Jul 2006 12:39:52 +0200
John,
According a Oracle documentation
START_DATE TIMESTAMP(6) WITH TIME ZONE Original scheduled start date of
the job (for an inline schedule)
And in this case is not a inline schedule.
You can read scheduler concepts in
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/schedover.htm#i1106753
You can know next_start_date:
SQL> SELECT schedule_name FROM
2 DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'GATHER_STATS_JOB';
SCHEDULE_NAME
-------------------------
MAINTENANCE_WINDOW_GROUP
SQL>
SQL> select w.window_name,w.start_date,w.repeat_interval,w.next_start_datefrom
dba_scheduler_windows w , dba_scheduler_wingroup_members g where
g.window_group_name = 'MAINTENANCE_WINDOW_GROUP' and g.window_name =
w.window_name;
WINDOW_NAME START_DATE REPEAT_INTERVAL
---------------- ---------------
-------------------------------------------------------------------
NEXT_START_DATE
---------------------------------------------
WEEKNIGHT_WINDOW
freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=22;byminute=0; bysecond=0
05/07/06 22:00:00,000000 +02:00
WEEKEND_WINDOW
freq=daily;byday=SAT;byhour=0;byminute=0;bysecond=0
08/07/06 00:00:00,000000 +02:00
Best Regards
On 7/5/06, Hallas, John, Tech Dev <John.Hallas@xxxxxxxxxxxxxxxxx> wrote:
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
--
Domingo Diaz Saenz
Other related posts:
gather_dictionary_stats runs automatically - how? RE: gather_dictionary_stats runs automatically - how? Re: gather_dictionary_stats runs automatically - how? Re: gather_dictionary_stats runs automatically - how?
