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?

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?

Accepted Answer

B. The database performance cannot be determined based only on this ratio.

Answer

A. The database performance is very good because of reduced logical I/Os.

Answer

C. Good database performance is guaranteed because very few physical I/Os are performed.

Answer

D. The database performance is very good because most of the requested data blocks are found in

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…

Question

Options

How the community answered

Community Discussion