Oracle
1Z0-054 · Question #58
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)…
The correct answer is B. This ratio is very high and the shared pool size should be increased immediately to reduce this. See the full explanation below for the reasoning.
Question
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?
Options
- AThis ratio is reasonable. However, decrease the shared pool size for better performance.
- BThis ratio is very high and the shared pool size should be increased immediately to reduce this
- CThis ratio is reasonable. However, this needs monitoring. Increase the shared pool size only if the
- DThis ratio is reasonable. However, this needs monitoring. Increase the shared pool size only if the
How the community answered
(60 responses)- A10% (6)
- B82% (49)
- C3% (2)
- D5% (3)
Community Discussion
No community discussion yet for this question.