Re: Oracle 3.3.4 a performance dog?

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 17 Feb 1999 17:34:21 -0800
Message-ID: <36CB6E1C.52DE1830@us.oracle.com>

Drat! Just as I was about to reply on the basis of my 3.3.4 knowledge!

Seriously, I have worked at a number of sites that noticed a performance improvement with 7.3.4, and a small number of sites that noticed a performance degradation. There were changes in the optimizer between these two releases that made selects that did a lot of in-list processing (select ... where abc in (.....)) perform slower. The upside was that most sites noticed a performance improvement.

For those with the in-list processing, I tuned the SQL to remove the in-list and things worked fine. The only problem I ran into was one site where the SQL was packaged and I couldn't do much about it.

HTH. Pete

Bruce wrote:

> Excuse the typos, I meant 7.3.4 not 3.3.4
>
> > We are currently running Oracle 7.2.2.3 (DecisionPoint) and 7.3.3
> > (Peoplesoft) - we are planning to upgrade everything to 7.3.4 but have
> just
> > been told that 7.3.4 has performance problems. Can anyone confirm/ deny/
> > comment on this?
> > --
> > any opinions expressed are my own
> > website: http://www.winzurf.co.nz
> > work: bruce.spedding_at_dia.govt.nz
> > play: bruce_at_winzurf.co.nz
> >

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Feb 17 1999 - 19:34:21 CST