DB Wiki

This is an old revision of the document!

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.clear_pending_area;
  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                => 3, 
    utilization_limit     => 100,
    parallel_server_limit => 100);

  DBMS_RESOURCE_MANAGER.create_cdb_plan_directive(
    plan                  => 'example_cdb_plan', 
    pluggable_database    => 'pdb2', 
    shares                => 3, 
    utilization_limit     => 100,
    parallel_server_limit => 100);

  DBMS_RESOURCE_MANAGER.validate_pending_area;
  DBMS_RESOURCE_MANAGER.submit_pending_area;
END;
/