Performance Tuning - Question 022

Which of the following columns will you use to calculate the library cache hit ratio? (Choose two.)

A . KEEPS

B. PINS

C. RELOADS

D . GETS

E . GETMISSES

Explanation:

Answer B and C: Here's the formula for the library cache hit ratio, selected from V$LIBRARYCACHE: ((PINS-RELOADS)/PINS)*100. The library cache hit ratio should be greater than 90 percent.