disable the mainteance plan using this syntax
WEEKNIGHT_WINDOW
WEEKEND_WINDOW
MONDAY_WINDOW
TUESDAY_WINDOW
WEDNESDAY_WINDOW
THURSDAY_WINDOW
FRIDAY_WINDOW
SATURDAY_WINDOW
SUNDAY_WINDOW
9 rows selected.
SQL> execute dbms_scheduler.set_attribute('WEEKEND_WINDOW', 'RESOURCE_PLAN','');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> /
Commit complete.
SQL> execute dbms_scheduler.set_attribute('FRIDAY_WINDOW', 'RESOURCE_PLAN','')
PL/SQL procedure successfully completed.
SQL> execute dbms_scheduler.set_attribute('SATURDAY_WINDOW', 'RESOURCE_PLAN','')
PL/SQL procedure successfully completed.
SQL> alter system set resource_manager_plan='';
System altered.
SQL> select window_name from DBA_SCHEDULER_WINDOWS;
WINDOW_NAME
WEEKNIGHT_WINDOW
WEEKEND_WINDOW
MONDAY_WINDOW
TUESDAY_WINDOW
WEDNESDAY_WINDOW
THURSDAY_WINDOW
FRIDAY_WINDOW
SATURDAY_WINDOW
SUNDAY_WINDOW
9 rows selected.
SQL> execute dbms_scheduler.set_attribute('WEEKEND_WINDOW', 'RESOURCE_PLAN','');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> /
Commit complete.
SQL> execute dbms_scheduler.set_attribute('FRIDAY_WINDOW', 'RESOURCE_PLAN','')
PL/SQL procedure successfully completed.
SQL> execute dbms_scheduler.set_attribute('SATURDAY_WINDOW', 'RESOURCE_PLAN','')
PL/SQL procedure successfully completed.