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 <code>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; /