Oracle中的异常事件resmgr:cpu quantum

Changes between 10g and 11g.

Resource Manager:

Subject	10g	11g
Maintenance Window	2 windows, WEEK and WEEKEND	Each day has its own window
Resource manager	Not enabled per default	Default resource plan specified

 

Sql Tunning Advisory:

Oracle Database 11g, by default, the Automatic Tunning Optimizer runs regularly during the Oracle scheduler Maintenance window, as the new automated maintenance task called the SQL Tunning Advisory task.

So this is a default behavior in Oracle 11g.

Solution

1]. To disable the resource manager you can use the below steps.

++ set the current resource manager plan to null (or another plan that is not restrictive):

alter system set resource_manager_plan='' scope=both

++ 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',''); and
execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');

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

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

 

2]. To disable SQL tunning you can use the below procedure.  

BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
/