Oracle
1Z0-054 · Question #72
1Z0-054 Question #72: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.
Question
You work as a DBA and you have the responsibility of managing a large online transaction processing (OLTP) system. You used the following query during the performance tuning activity: SQL> SELECT (1-((phy.value-phyd.value) / (cur.value + con.value))) * 100 2 "Cache Hit ratio" 3 FROM v$sysstat cur, v$sysstat con, v$sysstat phy, v$sysstat phyd 4 WHERE cur.name = 'db block gets' 5 AND con.name = 'consistent gets' 6 AND phy.name = 'physical reads' 7 AND phyd.name = 'physical reads direct'; Cache Hit Ratio --------------- 98.43 Which understanding of this ratio is correct?
Options
- A98.43% of times the requests have found free buffers.
- B98.43% of the total number of requests used the buffer cache.
- C98.43% of times the requests were satisfied by performing physical I/Os.
- D98.43% of times the requests have found the required data blocks in the buffer cache.
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.