Re: Unlucky upgrade

Hi MARCOTULLI ARMANDO

Make sure

TIMED_STATISTICS =f alse

                 SQL_TRACE = false

Suhen

>>> teci_at_oracle-dba.com 10/05/00 05:20PM >>>
nope we're running production stuff using CBO same as you..

u playing with 8160 or 8162.

also when was the last time you analyzed the statistics?

joe

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: Joseph S. Testa
  INET: teci_at_oracle-dba.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).