YoureceivedcomplaintsaboutthedegradationofSQLqueryperfo

单项选择题

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 SQL Tuning Advisor on top SQL statements
C.run the Automatic Workload Repository （AWR） report
D.run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

1Z0-042