The CREATE_PLAN procedure is used to create a resource plan.
Syntax
DBMS_RESOURCE_MANAGER.CREATE_PLAN (
plan IN VARCHAR2,
comment IN VARCHAR2 DEFAULT'');
Parameters
| Parameter | Description |
|---|---|
| plan | The name of the resource plan. |
| comment | User comments. |
Examples
obclient> CALL DBMS_RESOURCE_MANAGER.CREATE_PLAN('DAY','The resource plan is used for transaction processing');
Query OK, 0 rows affected
obclient> CALL DBMS_RESOURCE_MANAGER.CREATE_PLAN('NIGHT','The resource plan is used for daily maintenance');
Query OK, 0 rows affected