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 >>
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:
Post a Comment