11g DEFAULT_MAINTENANCE_PLAN Disable

来源：互联网发布：吾生有涯而知无涯解析编辑：程序博客网时间：2024/04/29 18:00

disable the mainteance plan using this syntax

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.