Re: Oracle Upgrading = performance improvement?

"Axel Stahl" <stahl_at_pdg-online.de> wrote in message news:<3dfde8b1$1_at_news.celox.de>...

> we have a customer which has an Compaq Proliant
> Server with 2 PIII 500Mhz CPU's and 1 gig of RAM
> and Oracle 8.0.5 (Windows NT Server SP5) .

Are you running the ERP as well as Oracle in the same box? If so, check out for paging. Use the task manager.

>
> There can be many factors, that the ERP is running slow on that database,

You got that right...

> but my question is, if there are any known performance improvements
> from 8.0.5 to 8.1.7.3 ?

Yes, many.

> I ask this question to calculate, if it is worth the time, upgrading to
> 8.1.7.3
> so there are any chances to gain more speed.

More than likely yes. The cost-based optimizer in 8.0.5 is deranged, and I'm being very polite in describing it!

In many places that have upgraded, I've seen an immediate pick-up of appropriate indexes when going from 8.0.5 to 8.1.7.

Make sure you go to 8.1.7.3 or later.
8.1.7.0 will most likely cause you serious problems.

> P.S.: Does Oracle 8 run more fast, if we would just add another or maybe
> 2 additional Processors, does Oracle "use" them without any further actions?

Yes. But if you are CPU limited, better make sure that it is indeed Oracle that is chewing up this CPU? Once again, use task manager to find out, processes section.

Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam Received on Mon Dec 16 2002 - 17:11:35 CST