or the converse -- were you using CBO but have lost the statistics?
>From: Rod Corderey <RodCorderey_at_lane-associates.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: 815 much slower than 734
>Date: Wed, 17 May 2000 02:28:49 -0800
>
>were you using Rule based optimiser on your 7.3 instance, with perhaps
>optimizer_mode =choose on 8.1.5?
>
>If the 7.3 had been upgraded from earlier releases, the optimizer mode
>could have been set to rule to accomodate tuned execution plans.
>
>In your 8.1.5 , if optimizer mode is now choose but the tables have not
>been analyzed then full scans would occur.
>
>probably nothing to do with it, but .........:-)
>
>--
>Rod
>
>Lane Associates
>RodCorderey_at_Lane-Associates.com
>http://www.Lane-Associates.com
>
>Louis BROUILLETTE wrote:
> >
> >
> > Environment:
> > AIX 4.2.1
> > Oracle 8.1.5
> >
> > I migrated a test database from 7.3.4.5 to 8.1.5.
> > Anything obvious why the 8.1.5 database would be much slower than the
>7.3.4
> > database ? Is there an init parameter that I should change to make it
> > faster ?
> >
> > Louis Brouillette
> > Analyste en informatique (DBA)
> > Universite du Quebec a Trois-Rivieres
> > Tel: (819) 376-5011 ext. 2435
> > Email: Louis_Brouillette_at_uqtr.uquebec.ca
> > --
> > Author: Louis BROUILLETTE
> > INET: Louis_Brouillette_at_UQTR.UQuebec.CA
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
>--
>Author: Rod Corderey
> INET: RodCorderey_at_Lane-Associates.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
Received on Wed May 17 2000 - 09:25:28 CDT
