Add new comment

I recently got this error while trying to run a SQL Tuning Task against a SQL statement that was available in AWR but not currently in the library cache.
I got around it by locating the SQL in OEM and using SQL Worksheet to execute it:

• Go to the Performance Tab for your database.
• Select the Search SQL link.
• Check the "AWR Snapshots time Period" and select ALL from the dropdown.
• Enter identifying information for your SQL statement.
• Click Search.
• Select the AWR snapshots tab.
• Select the SQL ID of the statement you are interested in.
• You are now at the SQL Details screen which shows the Statistics/Activity/Plan/Plan Control/Tuning History/SQL Monitoring tabs.
• Click SQL Worksheet in the bottom right.
• A SQL Worksheet window will be presented with your SQL Statement already loaded.
• Click the Execute button.

Now your statement has been executed and has at least 1 execution plan available in the library cache. Now you can run SQL Tuning advisor on it and review its results. I have also read that you may be able to run SQL Tuning advisor if you can get the statement added to a SQL Tuning Set. I have not tried this yet but will report back if I can give it a shot.