| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Should we stop analyzing?
Right Jared,
But this is where the new 'learning CBO' comes into picture isn't it? in 10g CBO looks at the history and then modified the execution plans.
This is all from Oracle 10g propaganda sheets, I'll agree when I see it in action.
Raj
-----Original Message-----
Sent: Thursday, January 08, 2004 1:40 PM
To: Multiple recipients of list ORACLE-L
> Me thinks CBO is probably never going to be bug free.
> What works for you, won't work for me unless we run
> identical systems, it is a general purpose system,
> CBO doesn't know your system or data usage.
At this point it would seem beneficial to differentiate between a bug and a logic error.
Roughly, a bug would seem to be code that falls into one of two categories:
A logic error would be found in code that does exactly what the developer intended, but what the developer intended is the wrong thing to do.
This could be expanded to include the inability of CBO to properly identify a usage pattern.
just my opinion.
Jared
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jan 08 2004 - 12:49:25 CST
 |
 |