What is a resource plan directive?

What is a resource plan directive?

Rating:

A resource plan in itself does so little that the need of a resource plan directive arises. Resource plan directives create a complex resource plan and also allocate resources to sub-plans. An example that will clear the concept of creating sub-plans is given below:

BEGIN
   DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
   PLAN    => 'DAY',
   GROUP_OR_SUBPLAN     => 'SYS_GROUP',
   CPU_P1    => 100);
END;
/

This will create a plan directive at level 1 for the DAY plan.

BEGIN
   DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
   PLAN    => 'DAY',
   GROUP_OR_SUBPLAN     => 'DEPARTMENT',
   CPU_P2    => 50);
END;
/

This will create a plan directive (sub-plan directive) at level 2.

BEGIN
   DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
   PLAN    => 'DAY',
   GROUP_OR_SUBPLAN     => 'DEVELOPERS',
   CPU_P2    => 50);
END;
/

This will create a plan directive (sub-plan directive) at level 2.

BEGIN
   DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
   PLAN    => 'DAY',
   GROUP_OR_SUBPLAN     => 'OTHER GROUPS',
   CPU_P3    => 50);
END;
/

This will create a plan directive (sub-plan directive) at level 3.

The entire above example creates a total of four directives for the DAY plan. The first directive creates and allocates 100% of the CPU resources to the SYS_GROUP group. The second directive allocates 50 % of level 2 CPU resources to the department group (DEP_GROUP). The third directive allocates the other 50 % of CPU resources at level 2 to the developers consumer group (DEV_GROUP). The fourth directive allocates the entire 100% of the CPU resources at level 3 to the OTHER_GROUPS group.

The diagrammatic depiction of the above example is given below:



Note: The group at level 1 is a top-level plan and the rest of the groups are sub-plans.

Rating: