Managing SQL Tuning Sets

Before detailing how to manually run the SQL Tuning Advisor, let's first cover SQL tuning sets. As mentioned, SQL tuning sets are a grouping of SQL statements and associated execution metrics. SQL tuning sets are used as inputs to many of Oracle's tuning tools (such as the SQL Tuning Advisor and SQL Access Advisor). Therefore, it's critical that you understand how to create and manage SQL tuning sets. Figure 9-2 displays the SQL tuning set architecture.

images

Figure 9-2. SQL tuning set srchitecture

To fully comprehend how a SQL tuning set is populated, it's instructional to manually run queries that retrieve high-resource ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.