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 SQL Statements from the Cursor Cache

Loading SQL Statements from the Cursor Cache

You can load SQL statements from the cursor cache into the SQL tuning set. However, because only current and recent SQL statements are in the SQL cache, collecting these statements only once may result in a SQL tuning set this is not representative of the entire database workload.

To load SQL statements 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 Load SQL statements one time only.

  3. From the Data Source list, select Cursor Cache.

  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".