About SQL Tuning Advisor

SQL Tuning Advisor provides recommendations for improving the performance of SQL statements. You can run SQL Tuning Advisor directly from Query Window on SQL that you have entered. You can also run Oracle Performance Analyzer to tune your running application and if it detects poorly performing queries, it will prompt you to run SQL Tuning Advisor directly from the Oracle Performance Analyzer interface.

You can find the documentation for the SQL Tuning Advisor interface in the following two locations:

  • Action Node - Describes how to run SQL Tuning Advisor in Oracle Performance Analyzer in response to recommendations that SQL needs to be tuned.

  • Tuning SQL in Query Window - Describes how to launch SQL Tuning Advisor from Oracle Query Window.

Privileges

A user must be granted the ADVISOR privilege to be able to use SQL Tuning Advisor.

Licensing

SQL Tuning Advisor requires an Oracle Tuning Pack License. Dialog boxes appear to notify you of licensing requirements.

See Also

Oracle Performance Analyzer Interface | Tuning SQL in Query Window