Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

"The SQL has aged out of the cursor cache"

DBA_1Apr 26 2016 — edited Apr 27 2016

Hi Team,

While running the SQL Tunning advisor , I recieve ""The SQL has aged out of the cursor cache."

I am aware that sql is not in cache and that's why SQL Tunning is not able to run the query.

Is that any I can pull the query from AWR to cache , so that I can run SQL tunning optimizer OR is there nay way I can run SQL tunning advisor over query not in cache.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2016
Added on Apr 26 2016
#general-database-discussions
12 comments
3,970 views