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?

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

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

A.
Adding CPUs to systems showing increased wait time due to contention will improve response
time.

B.
Systems where the CPU time is dominant in comparison to the wait time have optimal response
time.

C.
Increase in wait time when the CPU time increases or remains the same indicates an increase
in the load on the system.

D.
Systems where the proportion of CPU time does not decrease significantly with increasing load
would most likely benefit from adding CPUs.

E.
The appearance of CPU time together with wait time in the Top 5 Event section of the AWR
report of a system always indicates high contention.



Leave a Reply 3

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


domq

domq

Why not C and E? Latch cause high CPU (because of spinnig) and are sympthons of high contention.

Michael

Michael

Because of the word ALWAYS.
There can be many reasons for high CPU time together with wait time.