Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Resetting execution plan

RE: Resetting execution plan

From: Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is>
Date: Thu, 30 Nov 2006 15:36:20 -0000
Message-ID: <5A8896FB2AFC5445A7DCFC5903CCA6B06FEBA3@W03856.li01r1d.lais.net>


Ahhhr.
It sucks so much this empiric time-variant CBO thing. Out of always bad and sometimes bad I prefer always bad.  

Ask any electronics engineer what problem he prefers: the constant one or no-no-but-yes-and-no-and-yes-and-no. I hope Oracle will realize it one day.    


From: LS Cheng [mailto:exriscer_at_gmail.com] Sent: 30. nóvember 2006 14:55
To: Laimutis Nedzinskas
Subject: Re: Resetting execution plan

Because of bind peeking, sometimes queries with good plans runs slowly.

What I am doing now is simply

alter table XXX logging;

since it's a DDL it invalidates all cursors referencing the table, not the behaviour wanted though

cheers

LSC On 11/30/06, Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is > wrote:

	The closest thing I can imagine is outline for that one statement. 
	But that would require session reconnect I guess.
	 
	Just wandering: Why would you like this behaviour? 



Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 30 2006 - 09:36:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US