Performance Tuning - Question 108

Database Resource Manager uses resource plans to determine resource limits for the set of users. Which statement is true in reference to resource plans?

A. Resource plans are set using profiles.

B. Only one resource plan can be stored in the database at one time.

C. The database can have many resources plans, but only one can be active at any one time.

D. The database can have many resources plans, and each user chooses which plan to belong to.

Answer: C

Explanation:

Oracle8i introduced a new feature, Resource Manager, which was designed to improve the allocation and management of server resources needed by application users. In Oracle 9i, it is possible to control numerous aspects of application processing via Resource Manager. The database can have many resources plans, but only one can be active at any one time.

Incorrect Answers

A: Resource plans are not set using profiles.

B: The database can have many resources plans.

D: Each user cannot choose which plan to belong to because only one plan can be active at any one time.

OCP: Oracle 9i Performance Tuning Study Guide, Jaseph C. Johnson, p. 517-547

Chapter 10: Operating System Tuning