Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple Instances of ORACLE

Re: Multiple Instances of ORACLE

From: BY <tyeh_at_csc.com>
Date: 1997/05/15
Message-ID: <337B1770.3A10@csc.com>#1/1

Paul McAdam wrote:
>
> Gerald M. Lewis wrote:
> >
>
> I would be carefull about having so many instances. I was running 12
> instances on a SPARC 20 until a month or two ago. I posted to this group
> about the performance problems we had. The result was that the total SGA
> of all the instances shouldn't be more that 30% of the total memomry.
> what this means is that you will have to have a server with a LOT of
> memory and a LOT of processor power(consider that fact that 22 instances
> would give you over 100 processes running without a single user logged
> on) to make this work.
> --
> Paul McAdam
> -----------------------------------------------------------------
> Union Bank of Switzerland / Schweizerische Bankgesellschaft
> email: paul.mcadam_at_ubs.ch

Where does the 30% number came from? What is the rational behind it? It seems very low. It should depends on how many connections and what other processes the system needs to support.

BY Received on Thu May 15 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US