Re: Wrong execution plan

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Wed, 10 Jun 2009 08:58:04 -0700
Message-ID: <2ead3a60906100858p287ead94l6d88a4f6db4a81ea_at_mail.gmail.com>



Joerg,

> I resolved the actual situation with removing the plan from the shared
> pool. After this the optimizer generated a plan with the primary key.

Be aware that bind peeking occurs even when Histograms are not present - changing LO/HI values also causes this and given the fact that the right plan was chosen when you flushed this from the shared pool, it is a probable cause. How are you collecting your stats, and what is the rate of change in lo/hi values? Investigate this line of thought and you will probably arrive at he root cause of the problem. We would appreciate it if you found anything and posted it back to the list.

-- 
John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 10 2009 - 10:58:04 CDT

Original text of this message