Hi Suhen,
SQL_TRACE is set to false, TIMED_STATISTICS=3Dtrue because we need to =
execute
utlbstat and utlestat.
In the previous version (8.0.5) we didn't get any problem.
Armando
> -----Messaggio originale-----
> Da: Suhen Pather [mailto:PatherS5_at_telkom.co.za]
> Inviato: venerd=EC 6 ottobre 2000 11.01
> A: Multiple recipients of list ORACLE-L
> Oggetto: Re: Unlucky upgrade
>=20
>=20
> Hi MARCOTULLI ARMANDO
>=20
> Make sure=20
>=20
> TIMED_STATISTICS =3Df alse=20
> SQL_TRACE =3D false
>=20
>=20
> Suhen
>=20
> >>> teci_at_oracle-dba.com 10/05/00 05:20PM >>>
> 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 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=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=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
> > also send the HELP command for other information (like =
subscribing).
>=20
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --=20
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.com=20
>=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
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Suhen Pather
> INET: PatherS5_at_telkom.co.za
>=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 Fri Oct 06 2000 - 05:41:54 CDT
