SQL Profiles

When SQL statements are performing poorly, SQL Tuning Advisor can be used to generate SQL Profiles to address the issues. SQL Tuning Advisor requires Oracle Diagnostics and Tuning licenses.

SQL Tuning Adviser can be invoked to create and recommend better execution plans. Once a SQL Profile has been created—with a better execution plan for example—the SQL Profile will automatically include a SPM baseline if the SPM feature is enabled. Accordingly, plan evolution will be in effect for the SQL Profile and the execution plan may automatically change for the better over time.