Oracle
1Z0-054 · Question #58
1Z0-054 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
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
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.