The DELETE_PLAN_DIRECTIVE procedure is used to delete a 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.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 group or subplan. |
Examples
obclient> BEGIN
DBMS_RESOURCE_MANAGER.DELETE_PLAN_DIRECTIVE('NIGHT','group2');
END ;