Examine the query output shown below:
SQL> SELECT sum(pins), sum(reloads), sum(reloads)/sum(pins)
FROM v$librarycache;
SUM(PINS) SUM(RELOADS) SUM(RELOADS)/SUM(PINS)
———- ———— ———————-
16479 16000 0.9709327
Which statement describes the correct interpretation of the reloads-to-pin ratio and the action to be
taken?
A.
This ratio is reasonable. However, decrease the shared pool size for better performance.
B.
This ratio is very high and the shared pool size should be increased immediately to reduce this
ratio.
C.
This ratio is reasonable. However, this needs monitoring. Increase the shared pool size only if
the ratio crosses 1.
D.
This ratio is reasonable. However, this needs monitoring. Increase the shared pool size only if
the ratio falls below 0.1.
the ratio is too high. RELOAD/PIN should be close to 0 🙂
So B is correct