Using SQL Statements from the Cache

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. On the SQL Access Advisor: Workload Source page, select Current and Recent SQL Activity.

2. Proceed to the next step, as described in "Running SQL Access Advisor: Filter Options".