Next Question >>
Question 1/45
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?
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?
