Which two conclusions can you draw about the database from these metrics?

View the Exhibit and examine the partial output from the following query in an online transaction processing (OLTP) database:
SQL>SELECT intsize_csec,metric_name,value, metric_unit
FROM v$sysmetric;
Which two conclusions can you draw about the database from these metrics? (Choose two.)

View the Exhibit and examine the partial output from the following query in an online transaction processing (OLTP) database:
SQL>SELECT intsize_csec,metric_name,value, metric_unit
FROM v$sysmetric;
Which two conclusions can you draw about the database from these metrics? (Choose two.)

A.
The buffer cache is inadequately sized for the workload.

B.
Very few executions of SQL statements resulted in reparsing.

C.
There were no multipass executions in the Program Global Area (PGA).

D.
The database spends more time in wait events in comparison to statement processing.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is wrong. buffer cache hit ratio 95%
B is right. lib cache hit ratio 93%
C is wrong. nothing about multi-pass PGA
D is right. DB CPU time ratio 32%