===== Resource Manager =====
==== CDB Resource Plan ====
This will control the resource usage between pluggable databases.
Package / Procedures
DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN
DBMS_RESOURCE_MANAGER.DELETE_CDB_PLAN
DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE
DBMS_RESOURCE_MANAGER.UPDATE_CDB_PLAN_DIRECTIVE
DBMS_RESOURCE_MANAGER.DELETE_CDB_PLAN_DIRECTIVE
Views
DBA_CDB_RSRC_PLANS
DBA_CDB_RSRC_PLAN_DIRECTIVES
Examples
BEGIN
DBMS_RESOURCE_MANAGER.create_pending_area;
DBMS_RESOURCE_MANAGER.create_cdb_plan(
plan => 'example_cdb_plan',
comment => 'A test CDB resource plan');
DBMS_RESOURCE_MANAGER.create_cdb_plan_directive(
plan => 'example_cdb_plan',
pluggable_database => 'pdb1',
shares => 10, -- Number of shares (ie 10/25th)
utilization_limit => 50, -- Percent of CDBs CPU allowed
parallel_server_limit => 50); -- Percent of CDBs PARALLEL_SERVERS_TARGET available
DBMS_RESOURCE_MANAGER.create_cdb_plan_directive(
plan => 'example_cdb_plan',
pluggable_database => 'pdb2',
shares => 15,
utilization_limit => 50,
parallel_server_limit => 50);
DBMS_RESOURCE_MANAGER.validate_pending_area;
DBMS_RESOURCE_MANAGER.submit_pending_area;
END;
==== Automatic Consumer Group Switching ====
SWITCH_GROUP can now be set to LOG_ONLY, so a potential switch is logged but not performed.\\
New parameters are SWITCH_IO_LOGICAL and SWITCH_ELAPSED_TIME.