The CREATE_PLAN procedure creates a resource plan.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_RESOURCE_MANAGER.CREATE_PLAN (
plan IN VARCHAR2,
comment IN VARCHAR2 DEFAULT'');
Parameters
| Parameter | Description |
|---|---|
| plan | The name of the resource plan. |
| comment | The comments. |
Examples
obclient> CALL DBMS_RESOURCE_MANAGER.CREATE_PLAN('DAY','This resource plan is intended for transaction processing.');
Query OK, 0 rows affected
obclient> CALL DBMS_RESOURCE_MANAGER.CREATE_PLAN('NIGHT','This resource plan is intended for routine O&M.');
Query OK, 0 rows affected