Oracle
1Z0-074 · Question #6
1Z0-074 Question #6: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #6. The question stem and answer options stay visible for context.
Question
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?
Options
- Aby viewing Active Reports for that time period
- Bby enabling SQL trace for each query
- Cby running the Automatic Workload Repository (AWR) report for that time period
- Dby running the Active Session History (ASH) report for that time period
- Eby enabling tracing for sessions that run these queries
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.