Pluggable Databases - Expert Consolidation in Oracle Database 12c - page 263

DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE(
plan => 'SWINGBENCH_PLAN',
PLUGGABLE_DATABASE => 'swingbench1',
SHARES => 4,
UTILIZATION_LIMIT => null,
parallel_server_limit => 0);
-- repeat for swingbench2, reduce the number of
-- shares.
DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE(
plan => 'SWINGBENCH_PLAN',
PLUGGABLE_DATABASE => 'swingbench2',
SHARES => 2,
UTILIZATION_LIMIT => null,
parallel_server_limit => 0);
-- and for swingbench3
DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE(
plan => 'SWINGBENCH_PLAN',
PLUGGABLE_DATABASE => 'swingbench3',
SHARES => 2,
UTILIZATION_LIMIT => null,
PARALLEL_SERVER_LIMIT => 0);
end;
/
PL/SQL procedure successfully completed.
Validating and enabling the CDB Plan
With the pending area now created and our directives inside, you need to validate the pending area before you can
submit it. This is often performed in two steps:
SYS@CDB$ROOT> begin
2 dbms_resource_manager.validate_pending_area();
3 end;
4 /
PL/SQL procedure successfully completed.
SYS@CDB$ROOT> begin
2 dbms_resource_manager.submit_pending_area;
3 end;
4 /
PL/SQL procedure successfully completed.