Performance Tuning - Question 122

Which three are used when administering systems with the database Resource Manager? (Choose three)

A. Histograms

B. Explain Plan

C. Resource Plan

D. Resource User Group

E. Resource Consumer Group

F. Resource Plan Directives

G. Resource Plan Assignments

Answer: C, E, F

Explanation:

Resource Plan, Resource Consumer Group and Resource Plan Directives are used when administering systems with the database Resource Manager.

Incorrect Answers

A: Histograms are not used with the database Resource Manager.

B: Explain Plan has no relation with the database Resource Manager.

D: There is Resource Consumer Group, not Resource User Group in Resource Manager.

G: There is no Resource Plan Assignments for Resource Manager.

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

Chapter 10: Operating System Tuning