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!

Create outline with plan saved into AWR?

511158Nov 12 2009 — edited Jan 18 2011

Hello,

I'm trying to stabilize a query plan that tends to change from time to time.
By querying the AWR views I can identify the plan I want to use but in order to use it in a stored outline I need, if i am not mistaken, it to get loaded in the library cache.

How can I do (I don't know if it is even possible) to get an specific plan to get loaded into library cache to use it with an stored outline?
I've already tried re-executing the sql by hand (and substituting a ton of bind variables) but I only get suboptimal plans and not the one i want.

I'm using Oracle 10.2.0.4 64bit on Redhat AS x86_64.

Thanks in advance,
Frank.

Edited by: Frank R. on Nov 12, 2009 12:51 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2011

Added on Nov 12 2009

#general-database-discussions, #performance, #sql

4 comments

1,241 views