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. On the Create SQL Tuning Set: Load Methods page, select Load SQL statements one time only.

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

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

4. Click Next.

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

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