Fwd: Outlines not being used

Well, the good news is I'm not crazy. The bad news is that I hit an unpublished bug (Bug #3322366). If you're considering using stored outlines from test to production as we were, you might want to look this up. The gist is that 10.1, and 9.2.0.7 for us, you have to bounce the instance to get the stored outlines to get used.

Thank you to everyone who offered suggestions.

Kevin Lidh

• Forwarded message ---------- From: Kevin Lidh <kevin.lidh_at_gmail.com> Date: Mar 22, 2006 3:58 PM Subject: Outlines not being used To: oracle-l_at_freelists.org

I have what I hope is a simple question. We had a production issue where SQL that had been peforming well, stopped performing well. The execution plans were all of a sudden different. We went to our test system and created stored outlines which had the old (and good) execution plans. We exported those and imported them into production. The test system has been upgraded to 9.2.0.7.0 and the production system is 9.2.0.4.0. What is odd is that despite having the use_stored_outlines set to TRUE (and some outlines are being picked up), none of the new outlines are being used yet the hash_values are being called.

Does version matter or is it more likely that it's something else?

--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 03 2006 - 10:10:34 CDT