Databases Reference
In-Depth Information
Figure 9-5. Scheduling SQL Tuning Advisor jobs from Enterprise Manager
From here you can run a SQL Tuning Advisor tuning task on the top SQL statements or SQL in the
AWR, or provide a SQL tuning set as input.
Summary
The SQL Tuning Advisor is a flexible tool that provides performance tuning advice regarding indexes,
SQL profiles, statistics, restructuring queries, and so on. Because this tool generates advice regarding
indexes, we felt it was appropriate to cover the use of the SQL Tuning Advisor in this topic.
One key input to the SQL Tuning Advisor is through SQL tuning sets. Therefore, we also covered the
management of SQL tuning sets in this chapter. Briefly, a SQL tuning set is a collection of one or more
SQL statements and the associated execution metrics. You can populate a SQL tuning set either from
high resource SQL in the AWR or in memory.
The SQL Tuning Advisor can be invoked from the
DBMS_SQLTUNE
PL/SQL package, SQL Developer, or
Enterprise Manager. Which tool you use depends on what you have installed in your environment and
your comfort level with a manual approach versus a graphical interface.
