The CREATE_PLAN_DIRECTIVE procedure creates a resource plan directive.
Syntax
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (
plan IN VARCHAR2,
group_or_subplan IN VARCHAR2,
comment IN VARCHAR2 DEFAULT'',
mgmt_p1 IN NUMBER DEFAULT 100,
utilization_limit IN NUMBER DEFAULT 100);
Parameters
| Parameter | Description |
|---|---|
| plan | The name of the resource plan. |
| group_or_subplan | The name of the resource consumer group or subplan. |
| comment | The comments on the plan directive. |
| mgmt_p1 | The percentage of CPU resources allocated to the resource consumer group when the system runs at full load. |
| utilization_limit | The maximum CPU utilization allowed. Value range: [0,100]. The value 100 indicates that all CPU resources of the tenant can be used. The value 20 indicates that at most 20% of the CPU resources of the tenant can be used. |
Examples
obclient [test]> CALL DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
PLAN=>'DAY',
GROUP_OR_SUBPLAN=>'group1',
mgmt_p1=>80,
utilization_limit=>100);
Query OK, 0 rows affected
obclient [test]> CALL DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
PLAN=>'NIGHT',
GROUP_OR_SUBPLAN=>'group2',
mgmt_p1=>20,
utilization_limit=>40);
Query OK, 0 rows affected