Oracle
1Z0-054 · Question #146
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…
The correct answer is B. A change to the database configuration reduced the % DB time for transactions. D. A reduction in Hard Parse activity resulted in a reduction of DB CPU Time (in seconds). See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- AMore CPU time was used for background processes in the first time period.
- BA change to the database configuration reduced the % DB time for transactions.
- CMore of DB Time was consumed by background processes in the first time period.
- DA reduction in Hard Parse activity resulted in a reduction of DB CPU Time (in seconds).
- EMore transactions were processed in the first time period based on the DB Time values.
How the community answered
(24 responses)- A8% (2)
- B75% (18)
- C4% (1)
- E13% (3)
Community Discussion
No community discussion yet for this question.