Re: Oracle Instances (overhead)

From: Charles Walker <hgw_at_rosecyn.sannet.gov>
Date: 1997/07/02
Message-ID: <33BAC8B0.B0571065@rosecyn.sannet.gov>#1/1

John Bush wrote:

> Can anyone tell me what kind of overhead is associated with an oracle
> instance and database?
>
> For example , if I have 1 instance , and want a second , will it take
> up
> twice as much memory and disk space. So I guess the quesstion is, is
> it
> like running a second oracle sever, or is there sharing of resources?
>
> thanks
> Joel Nylund
>
> Please post replies to joel_nylund_at_mail.amsinc.com or
> jnylund_at_gmu.edu!

The instances will use twice the memory since tou will have double the background processes running and two SGAs, assuming you make the SGA the same size.
The only shared resource would be the software(Oracle) itself. The answer to the amount of overhead cunsumed by the software can be found in the Server Administrators Guide. Received on Wed Jul 02 1997 - 00:00:00 CDT