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.)
Exhibit:

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.

Show Hint

Leave a Reply 3

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

Rodge

Rodge

I don’t understand why D is correct – can anyone please explain?

Reply

max

max

wrong A as 95% buffer hit ratio is ok and not at all inadequately sized.
wrong C as you can not tell something concerning ‘multiples’ with the above information.

Reply