Database Administration (MOSC)

MOSC Banner

About the auto scheduled job GATHER_STATS_JOB

edited Oct 28, 2010 1:39AM in Database Administration (MOSC) 9 commentsAnswered
Hi,
When I run the following query in my system , I found 2 rows in return :

SELECT a.job_name, a.enabled,c.window_name,c.repeat_interval
FROM
   dba_scheduler_jobs                       a,
   dba_scheduler_wingroup_members b,
   dba_scheduler_windows                 c
WHERE job_name='GATHER_STATS_JOB'
And       a.schedule_name=b.window_group_name
And       b.window_name=c.window_name;


JOB_NAME                    ENABLED    WINDOW_NAME                   REPEAT_INTERVAL
GATHER_STATS_JOB    TRUE           WEEKEND_WINDOW            freq=daily;byday=SAT;byhour=0;byminute=0;bysecond=0
GATHER_STATS_JOB    TRUE           WEEKNIGHT_WINDOW         freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=22;byminute=0; bysecond=0

My questions are :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center