Oracle Database Administration II — Question 173

SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases.

Which action could help in the performance management of these regressed SQL statements?

Answer options

• A. Create SQL plan directives for each of the regressed statements.
• B. Use the SQL Tuning Advisor for each of the regressed statements.
• C. Use the SQL Access Advisor for each of the regressed statements.
• D. Create an adaptive execution plan for each of the regressed statements.

Correct answer: B

Explanation

The SQL Tuning Advisor is specifically designed to analyze and recommend optimizations for SQL statements, making it the most effective option for addressing performance regressions. While the other options may offer some benefits, they do not directly focus on tuning SQL statements as the SQL Tuning Advisor does.