RE: Unlucky upgrade

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Mon, 9 Oct 2000 13:46:43 +0530
Message-Id: <10644.118761@fatcity.com>

MARCOTULLI What O.S. are you using ? Is the Bug with a Particular O.S. (or in ALL = O.S.)
?
Does it trigger under certain conditions ?

NOTE - We are considering upgrading from 7.3.4 to 8.1.6 for Databases = on
Digital

Thanks

> -----Original Message-----
> From: MARCOTULLI ARMANDO [SMTP:AMarcotulli_at_grupposiac.it]
> Sent: Friday, October 06, 2000 1:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: R: Unlucky upgrade

>=20

> We set OPTIMIZER_MODE to CHOOSE and ran the ANALYZE last july.
> Oracle suggested us to delete all statistics as work around.
> It wasn't fine.
> The patchset is 8162.
> I forgot to say that once the instances were upgraded we have gotten =
some
> kilos of ORA-600 due to SORT_AREA_SIZE parameter, another bug =
corrected in
> 8.1.7
> Maybe the solution is an amulet to put near the server...

>=20
>=20


> > -----Messaggio originale-----

> > Da: Joseph S. Testa [mailto:teci_at_oracle-dba.com]

> > Inviato: gioved=EC 5 ottobre 2000 17.21

> > A: Multiple recipients of list ORACLE-L

> > Oggetto: Re: Unlucky upgrade

> >=20

> >=20

> > nope we're running production stuff using CBO same as you..

> >=20

> > u playing with 8160 or 8162.

> >=20

> > also when was the last time you analyzed the statistics?

> >=20

> > joe

> >=20

> >=20

> > MARCOTULLI ARMANDO wrote:

> >=20

> > > 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=20

> > users are very

> > > angry because of long response time.

> > > This nightmare is caused by the new optimizer: a full scan=20

> > 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=20

> > 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 /=20
> > 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).
> >=20
> > --=20
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --=20
> > Author: Joseph S. Testa
> > INET: teci_at_oracle-dba.com
> >=20
> > 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).
> >=20
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: MARCOTULLI ARMANDO
> INET: AMarcotulli_at_grupposiac.it

>=20


> 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 Mon Oct 09 2000 - 03:16:43 CDT