RE: Mutating (SQL) execution plan!?...is that possible...stranges t thing I have every seen

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Mutating (SQL) execution plan!?...is that possible...stranges t thing I have every seen

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Thu, 10 Mar 2005 10:08:38 -0800
Message-ID: <960A9B249C99994AA3C7FCA016A0DA89CB7A43@ussccem08.corp.hds.com>

Chris,

>>>I have the feeling you are setting yourself up for the=3D20 bind=20
>>>variable peeking trap and appear to be falling into it.

I am NOT a fan of using hidden parameters, but just be aware of the hidden parameter '_optim_peek_user_binds' (which is set to TRUE by default and enables bind peeking), that when set to FALSE in this case would take care of your "problem". Histograms *are* a useful tool when used appropriately, and can be a great help (and also a hindrance as you have seen).

Hth,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Fear connects you to the Negative, but Faith connects you to the Positive! I Jn 4:18

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 Thu Mar 10 2005 - 13:12:03 CST