How Resource Plan Directives Interact--多个执行命令都引用了同一个用户组

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm#ADMIN027

How Resource Plan Directives Interact

If there are multiple resource plan directives that refer to thesame consumer group, then the following rules apply for specificcases:

1. The parallel degree limit for the consumer group will bethe minimum of all the incoming values.

2. The active session pool for the consumer group will be thesum of all the incoming values and the queue timeoutwill be the minimum of all incoming timeoutvalues.

3. If there is more than one switch group and more than one switchtime, the Database Resource Manager will choose the mostrestrictive of all incoming values. Specifically:

   • SWITCH_TIME = min (all incomingover_switch_time values)

   • SWITCH_ESTIMATE = TRUE overridesSWITCH_ESTIMATE = FALSE

     Notes:

     • If both plan directives specify the same switch time, butdifferent switch groups, then the choice as to which group toswitch to is statically but arbitrarily decided by the DatabaseResource Manager.

     • You cannot specify both SWITCH_TIME andSWITCH_TIME_IN_CALL plan directives for a singleconsumer group.

4. If a session is switched to another consumer groupbecause it exceeds its switch time, that session will execute evenif the active session pool for the new consumer group isfull.

5. The maximum estimated execution time will be the mostrestrictive of all incoming values. Specifically:

   MAX_EST_EXEC_TIME = min (all incomingMAX_EST_EXEC_TIME values)