You receive complaints about poor performance in an Oracle 12c database while long running queries execute.
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution. How would you achieve this?
A. by viewing Active Reports for that time period
B. by enabling SQL trace for each query
C. by running the Automatic Workload Repository (AWR) report for that time period
D. by running the Active Session History (ASH) report for that time period
E. by enabling tracing for sessions that run these queries
|
Download Printable PDF. VALID exam to help you PASS. |
 |