CREATE_PLAN

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

CALL DBMS_RESOURCE_MANAGER.CREATE_PLAN('DAY','This resource plan is for transaction processing');
Query OK, 0 rows affected

CALL DBMS_RESOURCE_MANAGER.CREATE_PLAN('NIGHT','This resource plan is for daily maintenance');
Query OK, 0 rows affected