RE: Resetting execution plan
- From: "Laimutis Nedzinskas" <Laimutis.Nedzinskas@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Nov 2006 15:36:20 -0000
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@xxxxxxxxx]
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@xxxxxxxxxxxxx > 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
Other related posts:
