|
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: 3: There is no MAX_SESS_POOL resource plan parameter in Oracle. Reference: OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 122-129 Chapter 3: Manageability Enhancements
|