resmgr:cpu quantum & resource_manager_plan

11g:
关闭任务：
alter system set RESOURCE_MANAGER_PLAN = '';
或者
alter system set RESOURCE_MANAGER_PLAN = 'FORCE:';

关闭资源管理收集
alter system set "_resource_manager_always_on"=FALSE scope=spfile sid='*';
alter system set "_resource_manager_always_off"=TRUE scope=spfile sid='*';

show parameter resource_manager_plan
alter system set resource_manager_plan='' scope=both sid='*';

execute dbms_scheduler.set_attribute('SATURDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('SUNDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('MONDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('TUESDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEDNESDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('THURSDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('FRIDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');

select window_name from dba_scheduler_windows;

19c:
alter system set "_resource_manager_always_off"=TRUE scope=spfile sid='*';

在等待事件列表中，出现大量的resmgr:cpu quantum等待事件，参考MOS：High “Resmgr:Cpu Quantum” Wait Events In 11g Even When Resource Manager Is Disabled (Doc ID 949033.1)
Health Check Alert: Disable operating system NUMA support by turning NUMA off (Doc ID 957637.1)

show parameter undo
set lines 200 pages 50000
col name for a40
col value for a10
col describ for a60
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
  FROM SYS.x$ksppi x, SYS.x$ksppcv y
 where x.indx = y.indx
   AND x.ksppinm in ('_resource_manager_always_on'，'_resource_manager_always_off');

11g环境：
NAME                                     VALUE      DESCRIB
---------------------------------------- ---------- ------------------------------------------------------------
_resource_manager_always_off             FALSE      disable the resource manager always
_resource_manager_always_on              TRUE       enable the resource manager always

19c环境：
NAME                                     VALUE      DESCRIB
---------------------------------------- ---------- ------------------------------------------------------------
_resource_manager_always_off             FALSE      disable the resource manager always

select name,is_top_plan from v$rsrc_plan;

11g环境：
NAME                                     IS_TO
---------------------------------------- -----
INTERNAL_PLAN                            TRUE

19c环境：
NAME                                     IS_TO
---------------------------------------- -----
ORA$INTERNAL_CDB_PLAN                    TRUE
INTERNAL_PLAN                            TRUE
INTERNAL_PLAN                            TRUE