Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unlucky upgrade

Re: Unlucky upgrade

From: David Turner <turner_at_tellme.com>
Date: Thu, 5 Oct 2000 14:19:59 -0700
Message-Id: <10640.118652@fatcity.com>


All I was saying is that many of out queries performed poorly after the upgrade. We used quite a few hints to get the queries back to their original times.

Sorry for any confusion, Dave Turner

On Thu, Oct 05, 2000 at 01:05:40PM -0800, Pankaj Behl wrote:
> 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
>
>
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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
> http://profiles.msn.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Pankaj Behl
> INET: pbehl_at_hotmail.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
Received on Thu Oct 05 2000 - 16:19:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US