Re: Unlucky upgrade

Hey,

Does this mean we have this problem magnified when we use hints or hints are one of the ways to reduce the effect of this 'bug'

Pankaj

From: "Sandy Druar" <sdruar_at_eckerd.com>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Re: Unlucky upgrade
Date: Thu, 05 Oct 2000 12:05:26 -0800

Does this only effect the Sun Solaris platform?

Thanks

Sandy Druar
Oracle DBA
sdruar_at_eckerd.com

David Turner wrote:

> Yeah we ran into the same thing. All I can say is we have hints
everywhere now.
>
> Dave
>
> On Thu, Oct 05, 2000 at 06:05:43AM -0800, MARCOTULLI ARMANDO wrote:
> > Two weeks ago we upgraded our instances from 8.0.5 to 8.1.6.
> > This was the worst thing we could do.
> > The consume of CPUs have increased from 50% to 90% and our users are
very
> > angry because of long response time.
> > This nightmare is caused by the new optimizer: a full scan on the same
table
> > on 8.0.5 took 5 seconds, on 8.1.6 takes about 50 seconds!!!
> > Oracle opened a bug 10 days ago... it seems a BIG bug.
> > I am not asking a solution to the list, I'd like to know if there are
other
> > installations getting bad performances in 8.1.6.
> > How is it possible this problem is not already known?
> > Are we alone in the world running 8.1.6 on Solaris 2.6?
> >
> > Greets
> >
> > Armando Marcotulli
> > DB2/ORACLE DBA
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: MARCOTULLI ARMANDO
> > INET: AMarcotulli_at_grupposiac.it
> >
> > 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Turner
> INET: turner_at_tellme.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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sandy Druar
   INET: sdruar_at_eckerd.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.

Share information about yourself, create your own public profile at