Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated? (Choose three.)
A. SWITCH_TIME
B. SWITCH_GROUP
C. MAX_SESS_POOL
D. SWITCH_ESTIMATE
Answer: A, B, D
Explanation:
You can specify the maximum estimated time to complete (in seconds) for an operation by assigning a value the MAX_EST_EXEC_TIME parameter; the default value for this parameter is UNLIMITED. Oracle will estimate the time the operation with table will take. It the SWITH_ESTIMATE parameter is set to TRUE, and if Oracle’s estimate is greater than the value specified by MAX_EST_EXEC_TIME, Oracle will return an error and the operation will not be started. If the SWITCH_ESTIMATE parameter is FALSE, Oracle will start the operation even if Oracle’s estimate is greater than the value specified by MAX_EST_EXEC_TIME; Oracle will only switch groups based on other criteria being met. The SWITCH_GROUP parameter specifies the group to which the session will be switched. The SWITCH_TIME parameter specifies the amount of time a session can execute before it must be switched to another group. The default for the SWITCH_GROUP parameter is NULL; the default for the SWITCH_TIME parameter is UNLIMITED.
Incorrect Answers
C: There is no MAX_SESS_POOL resource plan parameter in Oracle.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 122-129
Chapter 3: Manageability Enhancements
No comments:
Post a Comment