It's Wednesday and my WEEKEND_WINDOW is open
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,
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,
0