Exit 1Z0-054 Oracle Database 11g: Performance Tuning
Question 4 of 5
0% complete
Q4 Multiple choice

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

Select all that apply.

  • 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.