Performance Tuning - Question 087

If a willing-to-wait latch request is satisfied on the first attempt, which statistic gets incremented?

A. GETS

B. SLEEPS

C. MISSES

D. IMMEDIATE_GETS

E. IMMEDIATE_MISSES

Answer: A

Explanation:

GETS is number of times a Willing-to_Wait latch was acquired without waiting. So GETS statistic will be incremented.

Incorrect Answers

B: SLLEPS statistic provides the number of times a process had to wait before obtaining a Willing-toWait latch.

C: MISSES shows the number of times a Willing-to_Wait latch was not acquired and a wait resulted.

D: IMMEDIATE_GETS is statistic of numbers of times an Immediate latch was acquired without waiting.

E: IMMEDIATE_MISSES is the number of times an Immediate latch was not acquired and a retry resulted.

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

Chapter 9: Tuning Contention