Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Resetting execution plan
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-lReceived on Thu Nov 30 2006 - 10:14:50 CST
![]() |
![]() |