Creating a SQL Tuning Set
This section describes how to create a SQL tuning set with Cloud Control.
To create a SQL tuning set:
-
Specify the initial options for the SQL tuning set, as described in "Creating a SQL Tuning Set: Options".
-
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 Methods".
-
Specify the filter options for the SQL tuning set, as described in "Creating a SQL Tuning Set: Filter Options".
-
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".