Re: gather_dictionary_stats runs automatically - how?

From: Domingo Diaz Saenz <domingo.diazs_at_gmail.com>
Date: Wed, 5 Jul 2006 12:39:52 +0200
Message-ID: <990cd870607050339u65b839f5s3cc10de4c8b72297@mail.gmail.com>

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_at_gb.vodafone.co.uk> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 05 2006 - 05:39:52 CDT