Re: Upgrading = performance improvement?

"Axel Stahl" <stahl_at_pdg-online.de> wrote in message news:3dfa074f_at_news.celox.de...
> Hello,
>
> 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) .

Old CPUs. Old O/S. Not very much RAM. Old Oracle.

> Unfortunately, since installing the new ERP-System which
> uses the Oracle-Database, the queries runs quite slow,
> due to the mass of queries and new function in the ERP-System.
> We are disappointed because we thought it would run not
> so slow, some invoices take 30 Seconds to be created within the ERP.

So what did they use before? Why the compulsion to use a large database product on out-of-date hardware -and an out-of-date version of said large database, too?

> There can be many factors, that the ERP is running slow on that database,
> but my question is, if there are any known performance improvements
> from 8.0.5 to 8.1.7.3 ?
> I ask this question to calculate, if it is worth the time, upgrading to
> 8.1.7.3

Of course it is. Not for speed, however, but because 8.1.7.4 is much more stable and has many more features.

> so there are any chances to gain more speed.

I strongly doubt it.

> 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, it will use them, provided the O/S sees them. Does NT Server use more than 2 processors, however?

And don't forget that you are required also to adjust your licensing fees with Oracle corporation if your original licence was for a 2 CPU box.

HJR
>
> Thanks,
> Axel
>
>
Received on Fri Dec 13 2002 - 10:26:00 CST