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: Charles Schultz <sacrophyte_at_gmail.com>
Date: Thu, 30 Nov 2006 10:14:50 -0600
Message-ID: <7b8774110611300814t61f8fd56lb85b1dbcfa3f4fd4@mail.gmail.com>


Wolfgang, you once mentioned that Graham Wood was waging a war against the developers on this very topic. Any updates on that internal conflict? =) From the abundance of "automatic" features that keep popping up including in 11g, it sounds like it is not going well for him.

On 11/30/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> At 08:36 AM 11/30/2006, Laimutis Nedzinskas wrote:
>
> 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.
>
>
> Don't count on it. In my view it is only going to get worse in Oracle 11
> when they activate the object cache hit statistics (it's already in 10 but
> disabled by default) and other dynamic CBO features.
>
>
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 30 2006 - 10:14:50 CST

Original text of this message

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