Which two are next steps to diagnose the problem further?

Reviewing Automatic Workload Repository (AWR) reports for CPU and I/O exceptions, the
time model displays SQL execution elapsed time as a major component of DB Time. Which two are next steps to diagnose the problem further?

Reviewing Automatic Workload Repository (AWR) reports for CPU and I/O exceptions, the
time model displays SQL execution elapsed time as a major component of DB Time. Which two are next steps to diagnose the problem further?

A.
Review Operating System processes for any zombies.

B.
Review SQL statistics from the Automatic Workload Repository (AWR).

C.
Run a STATSPACK report.

D.
Review Automatic Database Diagnostic (ADDM) recommendations.

E.
Review all system configuration parameters.



Leave a Reply 2

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