Create a Resource Manager plan 12c Non-CDB

-- creating a new resource plan steps --Note--12c product manual describes the need to enable resource manager as below with mgmt_p1=> no need use cpu_p1 begin dbms_resource_manager.create_pending_area(); end; / begin dbms_resource_manager.create_plan( plan => 'AUTOSTATS_CPU_SWITCH', comment => 'Switch CPU for Auto Maintenance jobs'); end; begin dbms_resource_manager.create_plan_directive(plan=> 'AUTOSTATS_CPU_SWITCH', group_or_subplan =>'ORA$AUTOTASK', comment => 'Switch CPU for Auto Maintenance…

Resource Manager SQLs on 12c Non-CDB

Helpful SQLs --if no rows return Resoruce Manager is not managing the CPU select name from v$rsrc_plan where is_top_plan='TRUE' and cpu_managed='ON'; select plan, cpu_method, status from dba_rsrc_plans order by 1; select consumer_group,cpu_method, status from dba_rsrc_consumer_groups order by 1; select plan, group_or_subplan, type, cpu_p1, cpu_p2, cpu_p3, cpu_p4, status from dba_rsrc_plan_directives where plan= 'DEFAULT_MAINTENANCE_PLAN' order by 1,2,3,4,5,6…