Performance Tuning - Question 116

Which two methods can you use to calculate the size of the recycle pool? (Choose two)

A. Total the buffer cache blocks used by the object.

B. Use the direct reads statistic from a tracing tool.

C. Use the physical reads statistic from a tracing tool.

D. Use the indirect reads statistic from a tracing tool.

Answer: B, C

Explanation:

To calculate the size of the recycle pool you can use the direct reads and the physical reads statistic from the tracing tool.

Incorrect Answers

A: Total the buffer cache blocks used by the object cannot be used for this purpose.

D: The indirect reads statistic from a tracing tool will not help you to calculate the size of the recycle pool.

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 205-208

Chapter 4: Tuning the Shared Pool