Oracle Upgrading = performance improvement?

From: Axel Stahl <stahl_at_pdg-online.de>
Date: Mon, 16 Dec 2002 15:52:58 +0100
Message-ID: <3dfde8b1$1@news.celox.de>

Hello,

sorry for posting this again, but I received no answers so I hope anybody can help me out there, last try ;-)))

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) . 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.

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
so there are any chances to gain more speed. 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?

Thanks,
Axel Received on Mon Dec 16 2002 - 08:52:58 CST