DB Wiki

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;

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.