关于CREATE_PLAN_DIRECTIVE Procedure与资源计划的平行度

文章地址：http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_resmgr.htm#sthref4828

CREATE_PLAN_DIRECTIVEProcedure

This procedure lets you create resource plan directives.

Syntax

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (
   plan                      IN VARCHAR2, 
   group_or_subplan          IN VARCHAR2, 
   comment                   IN VARCHAR2, 
   cpu_p1                    IN NUMBER   DEFAULT NULL, 
   cpu_p2                    IN NUMBER   DEFAULT NULL, 
   cpu_p3                    IN NUMBER   DEFAULT NULL, 
   cpu_p4                    IN NUMBER   DEFAULT NULL, 
   cpu_p5                    IN NUMBER   DEFAULT NULL, 
   cpu_p6                    IN NUMBER   DEFAULT NULL, 
   cpu_p7                    IN NUMBER   DEFAULT NULL, 
   cpu_p8                    IN NUMBER   DEFAULT NULL, 
   active_sess_pool_p1       IN NUMBER   DEFAULT NULL,
   queueing_p1               IN NUMBER   DEFAULT NULL,
   parallel_degree_limit_p1  IN NUMBER   DEFAULT NULL,
   switch_group              IN VARCHAR2 DEFAULT NULL,    
   switch_time               IN NUMBER   DEFAULT NULL, 
   switch_estimate           IN BOOLEAN  DEFAULT FALSE, 
   max_est_exec_time         IN NUMBER   DEFAULT NULL, 
   undo_pool                 IN NUMBER   DEFAULT NULL,
   max_idle_time             IN NUMBER   DEFAULT NULL,
               max_idle_blocker_time     IN NUMBER   DEFAULT NULL,
               switch_time_in_call       IN NUMBER   DEFAULT NULL); 

Parameters

Table 85-6 CREATE_PLAN_DIRECTIVE ProcedureParameters

Parameter	Description
plan	The name of the resource plan.
group_or_subplan	The name of the consumer group or subplan.
comment	Comment for the plan directive.
cpu_p1	For EMPHASIS, specifies the CPU percentage at thefirst level. For RATIO, specifies the weight of CPUusage. Default is NULL for all CPU parameters.
cpu_p2	For EMPHASIS, specifies the CPU percentage at thesecond level. Not applicable for RATIO.
cpu_p3	For EMPHASIS, specifies the CPU percentage at thethird level. Not applicable for RATIO.
cpu_p4	For EMPHASIS, specifies the CPU percentage at thefourth level. Not applicable for RATIO.
cpu_p5	For EMPHASIS, specifies the CPU percentage at thefifth level. Not applicable for RATIO.
cpu_p6	For EMPHASIS, specifies the CPU percentage at thesixth level. Not applicable for RATIO.
cpu_p7	For EMPHASIS, specifies the CPU percentage at theseventh level. Not applicable for RATIO.
cpu_p8	For EMPHASIS, specifies the CPU percentage at theeighth level. Not applicable for RATIO.
active_sess_pool_p1	Specifies maximum number of concurrently active sessions for aconsumer group. Default is NULL, which meansunlimited.
queueing_p1	Specified time (in seconds) after which a job in the inactivesession queue (waiting for execution) will time out. Default isNULL, which means unlimited.
parallel_degree_limit_p1	Specifies a limit on the degree ofparallelism for any operation. Default is NULL, whichmeans unlimited. --指定任何操作的平行度限制，默认为空值，即意味无限大。
switch_group	Specifies consumer group to which this session is switched ifother switch criteria is met. Default is NULL. If thegroup name is 'CANCEL_SQL', the current call will becanceled when other switch criteria are met. If the group name is'KILL_SESSION', the session will be killed when otherswitch criteria are met.
switch_time	Specifies time (in seconds) that a session can execute before anaction is taken. Default is NULL, which meansunlimited.
switch_estimate	If TRUE, tells Oracle to use its execution timeestimate to automatically switch the consumer group of an operationbefore beginning its execution. Default is FALSE.
max_est_exec_time	Specifies the maximum execution time (in seconds) allowed for asession. If the optimizer estimates that an operation will takelonger than MAX_EST_EXEC_TIME, the operation is notstarted and ORA-07455 is issued. If the optimizer does not providean estimate, this directive has no effect. Default isNULL, which means unlimited.
undo_pool	Sets a maximum in kilobytes (K) on the total amountof undo generated by a consumer group. Default isNULL, which means unlimited.
max_idle_time	Indicates the maximum session idle time. Default isNULL, which means unlimited.
max_idle_blocker_time	The maximum amount of time in seconds that a session can be idlewhile blocking another session's acquisition of a resource.
switch_time_in_call	Specifies time (in seconds) that a session can execute before anaction is taken. At the end of the top call, the consumer group ofthe session is restored to its original consumer group. Default isNULL, which means unlimited. BothSWITCH_TIME_IN_CALL and SWITCH_TIMEcannot be specified.

Usage Notes

• All parameters default to NULL. However, for theEMPHASIS CPU resource allocation method,this case would starve all the users.

• For max_idle_time andmax_idle_blocker_time, PMON will checkthese limits once a minute. If it finds a session that has exceededone of the limits, it will forcibly kill the session and clean upall its state.

• The parameter switch_time_in_call is mostly usefulfor three-tier applications where the mid-tier server isimplementing session pooling. By usingswitch_time_in_call, the resource usage of one clientwill not affect a future client that happens to be executed on thesame session.

---