Performance Tuning - Question 099

What is the least number of buffers an LRU latch must cover in the database buffer cache?

A. 5

B. 10

C. 30

D. 50

E. 100

Answer: D

Explanation:

There are at least 50 blocks per LRU latch for each pool.

Incorrect Answers

A: There are at least 50, not 5, blocks per LRU latch for each pool.

B: There are at least 50, not 10, blocks per LRU latch for each pool.

C: There are at least 50, not 30, blocks per LRU latch for each pool.

E: There are at least 50, not 100, blocks per LRU latch for each pool.

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

Chapter 9: Tuning Contention