Loading SQL Statements from AWR Baselines

You can load SQL statements captured in AWR baselines. This technique is useful when you want to collect SQL statements that are representative of a time period during known performance levels that can be used for later comparison or tuning purposes.

To load SQL statements from AWR baselines:

1. Access the Create SQL Tuning Set: Load Methods page, as explained in "Creating a SQL Tuning Set: Options".

2. Select Load SQL statements one time only.

3. In the Data Source field, select AWR Baseline.

4. In the AWR Baseline field, select the baseline to include.

   
   Description of the illustration sts_load_baseline.gif

5. Click Next.

   The Create SQL Tuning Set: Filter Options page is shown.

6. Proceed to the next step, as described in "Creating a SQL Tuning Set: Filter Options".