CREATE_PLAN Procedure

This procedure creates entries which define resource plans. For release 8.2, max_active_sess_target_mth was renamed active_sess_pool_mth and new_queueing_mth was added.

Syntax

DBMS_RESOURCE_MANAGER.CREATE_PLAN (
   plan                       IN VARCHAR2, 
   comment                    IN VARCHAR2, 
   cpu_mth                    IN VARCHAR2 DEFAULT 'EMPHASIS', 
   active_sess_pool_mth       IN VARCHAR2 DEFAULT 'ACTIVE_SESS_POOL_ABSOLUTE', 
   parallel_degree_limit_mth  IN VARCHAR2 DEFAULT 
                              'PARALLEL_DEGREE_LIMIT_ABSOLUTE',
   queueing_mth               IN VARCHAR2 DEFAULT 'FIFO_TIMEOUT',); 

Parameters

Table 53-2 CREATE_PLAN Procedure Parameters

Parameter	Description
plan	Name of resource plan.
comment	User's comment.
cpu_mth	Allocation method for CPU resources.
active_sess_pool_mth	Allocation method for maximum active sessions.
parallel_degree_limit_mth	Allocation method for degree of parallelism.
new_queueing_mth	Specifies type of queuing policy to use with active session pool feature.