You received complaints about the degradation of SQL query performance. You identified top SQL
queries that consume time. What would be your next step to find out recommendations about
statistics collection and restructuring of the SQL statement to improve query performance?
A.
run Segment Advisor
B.
run the Automatic Workload Repository (AWR) report
C.
run the Automatic Database Diagnostic Monitor (ADDM) on top SQL statements
D.
run SQL Tuning Advisor on top SQL statements