UPDATE_PLAN_DIRECTIVE Procedure

This procedure lets you update resource plan directives. For release 8.2 new_max_active_sess_target_mth was renamed new_active_sess_pool_mth and several new parameters added

Syntax

DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE (
   plan                          IN VARCHAR2, 
   group_or_subplan              IN VARCHAR2, 
   new_comment                   IN VARCHAR2 DEFAULT NULL, 
   new_cpu_p1                    IN NUMBER   DEFAULT NULL, 
   new_cpu_p2                    IN NUMBER   DEFAULT NULL, 
   new_cpu_p3                    IN NUMBER   DEFAULT NULL, 
   new_cpu_p4                    IN NUMBER   DEFAULT NULL, 
   new_cpu_p5                    IN NUMBER   DEFAULT NULL, 
   new_cpu_p6                    IN NUMBER   DEFAULT NULL, 
   new_cpu_p7                    IN NUMBER   DEFAULT NULL, 
   new_cpu_p8                    IN NUMBER   DEFAULT NULL, 
   new_active_sess_pool_p1       IN NUMBER   DEFAULT NULL,
   new_queueing_p1               IN NUMBER   DEFAULT NULL,
   new_parallel_degree_limit_p1  IN NUMBER   DEFAULT NULL
   new_switch_group              IN VARCHAR2 DEFAULT NULL, 
   new_switch_time               IN NUMBER   DEFAULT NULL, 
   new_switch_estimate           IN BOOLEAN  DEFAULT FALSE, 
   new_max_est_exec_time         IN NUMBER   DEFAULT NULL, 
   new_undo_pool                 IN NUMBER   DEFAULT UNLIMITED); 

Parameters

Table 53-10 UPDATE_PLAN_DIRECTIVE Procedure Parameters

Parameter	Description
plan	Name of resource plan.
group_or_subplan	Name of consumer group or subplan.
comment	Comment for the plan directive.
new_cpu_p1	First parameter for the CPU resource allocation method.
new_cpu_p2	Second parameter for the CPU resource allocation method.
new_cpu_p3	Third parameter for the CPU resource allocation method.
new_cpu_p4	Fourth parameter for the CPU resource allocation method.
new_cpu_p5	Fifth parameter for the CPU resource allocation method.
new_cpu_p6	Sixth parameter for the CPU resource allocation method.
new_cpu_p7	Seventh parameter for the CPU resource allocation method.
new_cpu_p8	Eighth parameter for the CPU resource allocation method.
new_active_sess_pool_p1	First parameter for the maximum active sessions allocation method (Reserved for future use).
new_queueing_p1	queue timeout in seconds
new_switch_group	group to switch into once switch time is reached
new_switch_time	switch time
new_switch_estimate	If TRUE, tells Oracle to use its execution time estimate to automatically switch the consumer group of an operation before beginning its execution. Default is FALSE.
new_max_est_exec_time	maximum estimated execution time in seconds
new_undo_pool	undo pool size for the consumer group, in Kbytes
new_parallel_degree_ limit_p1	First parameter for the degree of parallelism allocation method.

If the parameters for UPDATE_PLAN_DIRECTIVE are left unspecified, then they remain unchanged in the data dictionary.