The DELETE_PLAN procedure deletes the specified plan and all directives referenced by this plan.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
Syntax
DBMS_RESOURCE_MANAGER.DELETE_PLAN (
plan IN VARCHAR2);
Parameters
The plan parameter specifies the name of the resource plan to be deleted.
Examples
obclient> CALL DBMS_RESOURCE_MANAGER.DELETE_PLAN('NIGHT');
Query OK, 0 rows affected