Hyperion Drm Interview Questions and Answers - 2

Question: 6

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.

Question: 7

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.

Question: 8

What is a resource plan directive?

Resource plan directive is the key element in creating complex resource plans. It assigns consumer groups to resource plans and defines the resource allocation for each.

It can also allocate resources to sub plans.

Question: 9

What is an undo pool allocation method?

It is a resource plan directive parameter, which controls the total amount of undo (in KB) that can be generated by a consumer group or sub plan.

It can be set using the UNDO_POOL parameter.

The default value for this parameter is null which indicates that no limit is imposed

Question: 10

How can you manage operating system resources from the database?

You can use Database Resource Manager (DRM) to manage operating system resources.