Which two statements give a correct inference based on the DB Time and DB CPU in the Time Model Statistics?

You generate an AWR Compare Periods Report for two consecutive time periods as a routine
activity to monitor your database performance.View the Exhibit and examine the partial details of
the Time Model Statistics generated in the report.
Which two statements give a correct inference based on the DB Time and DB CPU in the Time Model Statistics? (Choose two.)

You generate an AWR Compare Periods Report for two consecutive time periods as a routine
activity to monitor your database performance.View the Exhibit and examine the partial details of
the Time Model Statistics generated in the report.
Which two statements give a correct inference based on the DB Time and DB CPU in the Time Model Statistics? (Choose two.)

A.
More CPU time was used for background processes in the first time period.

B.
A change to the database configuration reduced the % DB time for transactions.

C.
More of DB Time was consumed by background processes in the first time period.

D.
A reduction in Hard Parse activity resulted in a reduction of DB CPU Time (in seconds).

E.
More transactions were processed in the first time period based on the DB Time values.



Leave a Reply 3

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


L. Zhu

L. Zhu

A is wrong. DB CPU not CPU
B is right
C is wrong. can not tell
D is right.
E is wrong. can not tell

retard$

retard$

background elapsed does not contribute to DB time in any case..

dav

dav

same number of transactions