Oracle
1Z0-054 · Question #209
Which two inferences are correct about the CPU time and the wait time that appear in the Automatic Workload Repository AWR and Statspack reports in the Top 5 Event section? (Choose two.)
The correct answer is C. Increase in wait time when the CPU time increases or remains the same indicates an increase in D. Systems where the proportion of CPU time does not decrease significantly with increasing load. See the full explanation below for the reasoning.
Question
Which two inferences are correct about the CPU time and the wait time that appear in the Automatic Workload Repository AWR and Statspack reports in the Top 5 Event section? (Choose two.)
Options
- AAdding CPUs to systems showing increased wait time due to contention will improve response
- BSystems where the CPU time is dominant in comparison to the wait time have optimal response
- CIncrease in wait time when the CPU time increases or remains the same indicates an increase in
- DSystems where the proportion of CPU time does not decrease significantly with increasing load
- EThe appearance of CPU time together with wait time in the Top 5 Event section of the AWR
How the community answered
(30 responses)- A3% (1)
- B13% (4)
- C80% (24)
- E3% (1)
Community Discussion
No community discussion yet for this question.