1. Get Started with Performance Tuning
  2. SQL Tuning
  3. Tuning SQL Statements
  4. Managing SQL Tuning Sets
  5. Creating a SQL Tuning Set
  6. Creating a SQL Tuning Set: Load Methods
  7. Loading Active SQL Statements Incrementally from the Cursor Cache

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 run during a specified time period in the future.

To load active SQL statements incrementally from the cursor cache:

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

  2. Select Incrementally capture active SQL statements over a period of time from the cursor cache.

  3. In the Duration field, specify how long to capture active SQL statements.

  4. In the Frequency field, specify how often to capture active SQL statements during the specified duration.

  5. Click Next.

    The Create SQL Tuning Set: Filter Options page appears.

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