Automatic Consumer Group Switching is an important new feature of the Database Resource Manager.
Which three plan directive parameters are used to control this feature? (choose three)
A.
SWITCH_TIME
B.
SWITCH_GROUP
C.
MAX_SESS_POOL
D.
SWITCH_ESTIMATE
Explanation:
The SWITCH_CONSUMMER_GROUP_FOR_SESS causes the specified session to immediately be moved into the specified resource consumer group. In effect, this statement can raise or lower priority.
SWITCH_GROUP : Specifies consumer group to which this session is switched if other switch criteria are met. If the group name is ‘CANCEL_SQL’, then the current call will be canceled when other switch criteria are met. If the group name is ‘KILL_SESSION’, then the session will be killed when other switch criteria are met. Default is NULL. SWITCH_TIME : Specifies time (in seconds) that a session can execute before an action is taken. Default in UNLIMITED. You cannot specify both SWITCH_TIME and SWITCH_TIME_IN_CALL.
SWITCH_ESTIMATE : If TRUE, tells the database to use its execution time estimate to automatically switch the consumer group of an operation prior to beginning its execution. Default is FALSE.REF: Oracle(r) 10g Administrator Guide, 24-17
