Oracle
1Z0-074 · Question #6
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…
The correct answer is E. by enabling tracing for sessions that run these queries. Explanation/Reference: https://docs.oracle.com/database/121/TDPPT/tdppt_realtime.htm#TDPPT034
Using Advanced SQL Features
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
How the community answered
(60 responses)- A2% (1)
- B5% (3)
- C2% (1)
- D10% (6)
- E82% (49)
Explanation
Explanation/Reference: https://docs.oracle.com/database/121/TDPPT/tdppt_realtime.htm#TDPPT034
Topics
#SQL trace#execution plan statistics#performance diagnostics#session tracing
Community Discussion
No community discussion yet for this question.