Running the SQL Tuning Advisor

Figure 9-4 shows the SQL Tuning Advisor architecture. This tool takes as input any of the following:

  • Single SQL statement
  • SQL_ID from a statement in memory or the AWR
  • Set of SQL statements contained in a SQL tuning set

This tool provides useful advice regarding the creation of indexes, restructuring the SQL statement, stale statistics, and so on. You can manually execute the SQL Tuning Advisor from DBMS_SQLTUNE PL/SQL package, SQL Developer, or Enterprise Manager.

images

Figure 9-4. The SQL Tuning Advisor archiecture

Let's focus first on running the SQL Tuning Advisor through the DBMS_SQLTUNE PL/SQL package. To execute ...

Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial