The UPDATE_PLAN_DIRECTIVE procedure is used to update the resource plan directive.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE (
PLAN IN VARCHAR2,
GROUP_OR_SUBPLAN IN VARCHAR2,
NEW_COMMENT IN VARCHAR2 DEFAULT NULL,
NEW_MGMT_P1 IN INT DEFAULT NULL,
NEW_UTILIZATION_LIMIT IN INT DEFAULT NULL,
NEW_MIN_IOPS IN INT DEFAULT NULL,
NEW_MAX_IOPS IN INT DEFAULT NULL,
NEW_WEIGHT_IOPS IN INT DEFAULT NULL,
NEW_MAX_NET_BANDWIDTH IN INT DEFAULT NULL,
NEW_NET_BANDWIDTH_WEIGHT IN INT DEFAULT NULL);
Parameters
| Parameter | Description |
|---|---|
| PLAN | The name of the resource plan. |
| GROUP_OR_SUBPLAN | The name of the resource group or subplan. |
| NEW_COMMENT | The comment for the plan directive. |
| NEW_MGMT_P1 | Specifies the maximum CPU utilization relative to availability when the system is under full load. |
| NEW_UTILIZATION_LIMIT | The upper limit of CPU resource utilization. The value of this parameter ranges from [0, 100]. 100 indicates that the tenant can use all CPU resources. If the value is 20, the tenant can use up to 20% of CPU resources. |
| NEW_MIN_IOPS | Specifies the reserved IOPS resources for the resource group when I/O contention occurs, with a total not exceeding 100. |
| NEW_MAX_IOPS | Specifies the maximum IOPS resources that the resource group can use, with a total that can exceed 100. |
| NEW_WEIGHT_IOPS | Specifies the weight value for IOPS, with a total that can exceed 100. |
| NEW_MAX_NET_BANDWIDTH | Specifies the maximum network bandwidth that the resource group can use, with a total that can exceed 100. |
| NEW_NET_BANDWIDTH_WEIGHT | Specifies the weight value for network bandwidth, with a total that can exceed 100. |
Considerations
If no parameters are specified for the UPDATE_PLAN_DIRECTIVE procedure, the parameter values remain unchanged in the data dictionary.
To clear (set to zero or invalid) any numeric parameter in the resource plan directive, use the UPDATE_PLAN_DIRECTIVE procedure to set it to -1.
Examples
Update the comment for the resource directive of the resource group
group1bound to the resource planDAY.obclient [SYS]> delimiter //obclient [SYS]> BEGIN DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE('DAY','group1','Intermediate level group'); END ;//obclient [SYS]> delimiter ;Update the resource plan content of the resource group
big_groupbound to the resource planplan_afor CPU, IOPS, and network bandwidth resources.obclient [SYS]> delimiter //obclient [SYS]> BEGIN DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE( PLAN => 'plan_a', GROUP_OR_SUBPLAN => 'big_group', NEW_COMMENT => 'new', NEW_MGMT_P1 => 40, NEW_UTILIZATION_LIMIT => 60, NEW_MIN_IOPS => 20, NEW_MAX_IOPS => 100, NEW_WEIGHT_IOPS => 10, NEW_MAX_NET_BANDWIDTH => 60, NEW_NET_BANDWIDTH_WEIGHT => 60); END ;//obclient [SYS]> delimiter ;
References
For more information about how to update the resource plan directive, see Update the resource plan directive.