The UPDATE_PLAN_DIRECTIVE procedure is used to update resource plan directives.
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);
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 | The maximum CPU utilization in percentage when the system is fully loaded. |
| NEW_UTILIZATION_LIMIT | The CPU utilization limit. The value of this parameter ranges from 0 to 100. "100" indicates that the tenant can use all CPU resources. If the value is "20", the tenant can use up to 20% of the CPU resources. |
| NEW_MIN_IOPS | The reserved IOPS resources for the resource group when I/O contention occurs. The sum of this parameter and the value of the NEW_MAX_IOPS parameter cannot exceed 100. |
| NEW_MAX_IOPS | The maximum IOPS resources that can be used by the resource group. The sum of this parameter and the value of the NEW_MIN_IOPS parameter can exceed 100. |
| NEW_WEIGHT_IOPS | The weight of IOPS. The sum of this parameter and the value of the NEW_MIN_IOPS parameter can exceed 100. |
Considerations
If you do not specify parameters 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 a resource plan directive, set the parameter to -1 in the UPDATE_PLAN_DIRECTIVE procedure.
Examples
obclient> BEGIN
DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE('DAY','group1','Intermediate level group');
END ;