Database Administration (MOSC)

MOSC Banner

It's Wednesday and my WEEKEND_WINDOW is open

edited Apr 4, 2012 2:42AM in Database Administration (MOSC) 8 comments
Anyone run across this before?

I'm on Oracle 10.2.0.4, RAC.

My GATHER_STATS_JOB hasn't run this week yet.
Through some snooping around it appears that the weekend window is active but today is wednesday.
(yes, system date and time is correct).

SQL> select
  2     window_name,
  3     resource_plan,
  4     enabled,
  5     active
  6  from
  7     dba_scheduler_windows
  8  ;

WINDOW_NAME      RESOURCE_PLAN ENABLED    ACTIVE
---------------- ------------- ---------- ----------
WEEKNIGHT_WINDOW               TRUE       FALSE
WEEKEND_WINDOW                 TRUE       TRUE



But I can't get the window to close.

SQL> EXEC DBMS_SCHEDULER.close_window('SYS.WEEKEND_WINDOW');

PL/SQL procedure successfully completed.

SQL> @windows
SQL> select
  2     window_name,
  3     resource_plan,

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