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> BEGIN
DBMS_RESOURCE_MANAGER.CREATE_PLAN('DAY','This resource plan is intended for transaction processing.');
END ;
obclient> BEGIN
DBMS_RESOURCE_MANAGER.CREATE_PLAN('NIGHT','This resource plan is intended for routine O&M.');
END ;