The DELETE_PLAN_DIRECTIVE procedure deletes a resource plan directive.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_RESOURCE_MANAGER.DELETE_PLAN_DIRECTIVE (
plan IN VARCHAR2,
group_or_subplan IN VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| plan | The name of the resource plan. |
| group_or_subplan | The name of the resource consumer group or subplan. |
Examples
obclient> CALL DBMS_RESOURCE_MANAGER.DELETE_PLAN_DIRECTIVE('NIGHT','group2');
Query OK, 0 rows affected