RE: converting to the cost based optimizer

Steve and Stepane,

Take a look at Tim Gorman's 'Search for Intelligent life in the CBO' paper in the library section at http://www.evdbt.com', as well as some of my insights into the CBO (and the traps/pitfalls along the path from RBO to CBO) at 'http://www.geocities.com/john_sharmila/links.htm' (click on the paper link).

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the end of your journey in this earth?

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: paquette stephane [mailto:stephane_paquette_at_yahoo.com]
> Sent: Tuesday, November 19, 2002 1:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: converting to the cost based optimizer
>
>
> We will be in the same process soon.
> We'll have to consolidate over 100 instances to
> something between 40-60 instances and switch from RBO
> to CBO.
>
> Any tips are welcome.
>
>
> --- Steve McClure <smcclure_at_usscript.com> a écrit : >
> I am just starting to look at converting to the cost
> > based optimizer, and am
> > hoping a few of you can share insights from having
> > done so in the past. Our
> > application is an oltp system developed on 7.3.4.
> > We made liberal use of
> > +0 and other RBO "hints", and I am wondering if
> > these are going to cause us
> > troubles when switching to CBO.
> >
> > We have been on 8i since April of this year, and I
> > am just now starting to
> > gather information on the inner workings of the CBO.
> > I know it is where I
> > want to be, I am just looking to see how
> > painful/painless the transition
> > will be.
> >
> > Steve McClure
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Steve McClure
> > INET: smcclure_at_usscript.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).
>
> =====
> Stéphane Paquette
> DBA Oracle et DB2, consultant entrepôt de données
> Oracle and DB2 DBA, datawarehouse consultant
> stephane_paquette_at_yahoo.com
>
> __________________________________________________________
> Lèche-vitrine ou lèche-écran ?
> magasinage.yahoo.ca
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).