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.
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 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.
