You can use SQL statements from the cache as the workload source. However, only current and recent SQL statements are stored in the SQL cache, so this workload source may not be representative of the entire workload on your database.

To use SQL statements from the cache as the workload source:

1. Select the initial options, as described in "Selecting the Initial Options".

2. On the SQL Access Advisor: Workload Source page, select Current and Recent SQL Activity.

   
   Description of the illustration sql_access_source_cache.gif

3. Proceed to the next step, as described in "Applying Filter Options".