a2zinterviews

9.	What is an execution time limit?
	Execution time limit is a type of resource allocation method. It can be set using the MAX_EST_EXEC_TIME parameter. If this parameter is specified, Oracle estimates the execution time of the operation before starting the operation. If the estimated time exceeds the parameter value, the operation is not started. The default value for this parameter is null which indicates no estimated limit is imposed.
	Discuss Your Name Your Email-ID Your Answer

10.	What is an idle time?
	Idle time is used to specify the number of seconds that a session can remain idle before the session is killed. It can be set using the MAX_IDLE_TIME parameter. The default value of the parameter is null which indicates that no idle time limit is imposed.
	Discuss Your Name Your Email-ID Your Answer

11.	What is a resource plan?
	A resource plan is used to define resources distribution among different consumer groups or other resource plans. Resource plan prioritize the resource allocation through the use of 1 to 8 levels, in order of priority highest to lowest.
	Discuss Your Name Your Email-ID Your Answer

12.	Define resource consumer groups?
	A resource consumer group is used to classify users into logical group based on their resource consumption requirements.
	Discuss Your Name Your Email-ID Your Answer