Creating a SQL Tuning Set

This section describes how to create a SQL Tuning Set with Enterprise Manager.

To create a SQL Tuning Set: 

1. Specify the initial options for the SQL Tuning Set, as described in "Creating a SQL Tuning Set: Options".

2. Select the load method to use for collecting and loading SQL statements into the SQL Tuning Set, as described in "Creating a SQL Tuning Set: Load Method".

3. Specify the filter options for the SQL Tuning Set, as described in "Creating a SQL Tuning Set: Filter Options".

4. Schedule and submit a job to collect the SQL statements and load them into the SQL Tuning Set, as described in "Creating a SQL Tuning Set: Schedule".