oracle启用自动维护任务,禁用11g中的自动维护任务

这个是资源管理器的东东，在每天启动数据库的自动维护任务的时候，就会自动启动这个可以通过下面方法关闭

1. Set the current resource manager plan to null (or another plan that is not restrictive):

alter system set resource_manager_plan='' scope=both;

2. Change the active windows to use the null resource manager plan (or other nonrestrictive plan) using:

execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN','');

execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');

3. Then, for each window_name (WINDOW_NAME from DBA_SCHEDULER_WINDOWS), run:

execute dbms_scheduler.set_attribute('<window name>','RESOURCE_PLAN','');

SQL> select WINDOW_NAME from DBA_SCHEDULER_WINDOWS;

WINDOW_NAME

------------------------------

MONDAY_WINDOW

TUESDAY_WINDOW

WEDNESDAY_WINDOW

THURSDAY_WINDOW

FRIDAY_WINDOW

SATURDAY_WINDOW

SUNDAY_WINDOW

WEEKNIGHT_WINDOW

WEEKEND_WINDOW

9 rows selected.