Friday, 17 July 2015

How to disable DEFAULT_MAINTENANCE_PLAN from DBA_SCHEDULER_WINDOWS

select WINDOW_NAME,WINDOW_PRIORITY,ENABLED,RESOURCE_PLAN,NEXT_START_DATE, DURATION from DBA_SCHEDULER_WINDOWS

Output:
WINDOW_NAME        WIND ENABL RESOURCE_PLAN                  NEXT_START_DATE                              DURATION
------------------ ---- ----- ------------------------------ -------------------------------------------- --------------------
MONDAY_WINDOW      LOW  TRUE                                 20-JUL-15 01.00.00 AM AFRICA/JOHANNESBURG    +000 06:00:00
TUESDAY_WINDOW     LOW  TRUE  DEFAULT_MAINTENANCE_PLAN       21-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG    +000 03:00:00
WEDNESDAY_WINDOW   LOW  TRUE  DEFAULT_MAINTENANCE_PLAN       22-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG    +000 03:00:00
THURSDAY_WINDOW    LOW  TRUE  DEFAULT_MAINTENANCE_PLAN       23-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG    +000 03:00:00
FRIDAY_WINDOW      LOW  TRUE  DEFAULT_MAINTENANCE_PLAN       24-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG    +000 03:00:00
SATURDAY_WINDOW    LOW  TRUE  DEFAULT_MAINTENANCE_PLAN       18-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG    +000 03:00:00
SUNDAY_WINDOW      LOW  TRUE  DEFAULT_MAINTENANCE_PLAN       19-JUL-15 02.00.00 AM AFRICA/JOHANNESBURG    +000 06:00:00


Now to disable DEFAULT_MAINTENANCE_PLAN from DBA_SCHEDULER_WINDOWS

SQL> alter system set resource_manager_plan='' scope=both

SQL>execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN',''); and 
SQL>execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');

SQL>execute dbms_scheduler.set_attribute('SATURDAY_WINDOW','RESOURCE_PLAN',''); 
SQL>execute dbms_scheduler.set_attribute('SUNDAY_WINDOW','RESOURCE_PLAN','');
SQL>execute dbms_scheduler.set_attribute('MONDAY_WINDOW','RESOURCE_PLAN',''); 
SQL>execute dbms_scheduler.set_attribute('TUESDAY_WINDOW','RESOURCE_PLAN','');
SQL>execute dbms_scheduler.set_attribute('WEDNESDAY_WINDOW','RESOURCE_PLAN',''); 
SQL>execute dbms_scheduler.set_attribute('THURSDAY_WINDOW','RESOURCE_PLAN','');
SQL>execute dbms_scheduler.set_attribute('FRIDAY_WINDOW','RESOURCE_PLAN','');

SQL> select WINDOW_NAME,WINDOW_PRIORITY,ENABLED,RESOURCE_PLAN,NEXT_START_DATE, DURATION from DBA_SCHEDULER_WINDOWS;

WINDOW_NAME          WIND ENABL RESOURCE_PLAN NEXT_START_DATE                            DURATION       
-------------------- ---- ----- -------------------------------------------------------- ---------------
MONDAY_WINDOW        LOW  TRUE                20-JUL-15 01.00.00 AM AFRICA/JOHANNESBURG  +000 06:00:00
TUESDAY_WINDOW       LOW  TRUE                21-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG  +000 03:00:00
WEDNESDAY_WINDOW     LOW  TRUE                22-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG  +000 03:00:00
THURSDAY_WINDOW      LOW  TRUE                23-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG  +000 03:00:00
FRIDAY_WINDOW        LOW  TRUE                24-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG  +000 03:00:00
SATURDAY_WINDOW      LOW  TRUE                18-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG  +000 03:00:00

SUNDAY_WINDOW        LOW  TRUE                19-JUL-15 02.00.00 AM AFRICA/JOHANNESBURG  +000 06:00:00
Ref: 
Resource Manager and Sql Tuning Advisory DEFAULT_MAINTENANCE_PLAN (Doc ID 786346.1)

Now To make status column to False in DBA_SCHEDULER_WINDOWS 

Follow the below link
<< http://oracletechdba.blogspot.com/2015/07/how-to-make-status-column-to-false-in.html >>

No comments: