Which three plan directive parameters are used to control this feature?

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)

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *