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 0

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