Loading Active SQL Statements Incrementally from the Cursor Cache

You can load active SQL statements from the cursor cache into the SQL Tuning Set incrementally over a specified period of time. This technique enables you to not only collect current and recent SQL statements stored in the SQL cache, but also SQL statements that will run during a specified time period in the future.

To load active SQL statements incrementally from the cursor cache: 

1. On the Create SQL Tuning Set: Load Methods page, select Incrementally capture active SQL statements over a period of time from the cursor cache.

2. In the Duration field, specify how long active SQL statements will be captured.

3. In the Frequency field, specify how often active SQL statements will be captured during the specified duration.

4. Click Next.

   The Create SQL Tuning Set: Filter Options page appears.

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