UPDATE_PLAN Procedure

This procedure updates entries which define resource plans.For release 8.2 new_max_active_sess_target_mth was renamed new_active_sess_pool_mth and new_queueing_mth was added.

Syntax

DBMS_RESOURCE_MANAGER.UPDATE_PLAN (
   plan                           IN VARCHAR2, 
   new_comment                    IN VARCHAR2 DEFAULT NULL, 
   new_cpu_mth                    IN VARCHAR2 DEFAULT NULL, 
   new_active_sess_pool_mth           IN VARCHAR2 DEFAULT NULL,
   new_parallel_degree_limit_mth  IN VARCHAR2 DEFAULT NULL,
   new_queueing_mth                   IN VARCHAR2 DEFAULT NULL, 
   new_group_switch_mth               IN VARCHAR2 DEFAULT NULL); 

Parameters

Table 53-3 UPDATE_PLAN Procedure Parameters

Parameter	Description
plan	Name of resource plan.
new_comment	New user's comment.
new_cpu_mth	Name of new allocation method for CPU resources.
new_active_sess_pool_ mth	Name of new method for maximum active sessions.
new_parallel_degree_ limit_mth	Name of new method for degree of parallelism.
new_queueing_mth	Specifies type of queuing policy to use with active seesion pool feature.

Usage Notes

If the parameters to UPDATE_PLAN are not specified, then they remain unchanged in the data dictionary.