Re: Oracle Upgrading = performance improvement?

I will answer the part I know:

> 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?
>

Oracle server can run in two modes:

1. Dedicated server mode (default for most installations) : In this, each session that connects to the server creates a dedicated Oracle process on the server side. So, multiple processors should help if multiple sessions are connected and doing cpu intensive activities.
2. MTS mode (Multi-threaded server) : Oracle can be configured to run in this mode where there will be fixed number of server processes, (for example, 15) will serve any number of sessions connected.

In a nut shell, multi-processor should help in either case.

"Axel Stahl" <stahl_at_pdg-online.de> wrote in message news:3dfde8b1$1_at_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 - 12:39:16 CST