RE: Resetting execution plan

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