Oracle
1Z0-054 · Question #73
1Z0-054 Question #73: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Question
You work as a DBA and 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 What can you conclude based on this ratio?
Options
- AThe database performance is very good because of reduced logical I/Os.
- BThe database performance cannot be determined based only on this ratio.
- CGood database performance is guaranteed because very few physical I/Os are performed.
- DThe database performance is very good because most of the requested data blocks are found in
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.