Which statement describes the correct interpretation of the reloads-to-pin ratio and the action to be taken?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

the ratio is too high. RELOAD/PIN should be close to 0 🙂

So B is correct