Re: Oracle: how many instances?

    If you're running 32 bit Oracle, you have a 1.75 (at best) Gb memory limit. Theoretically, you can simultaneously run as many instances as allowed by the 1.75 Gb memory limit with 32 bit Oracle. One thing to consider when allocating your SGA's is the amount of memory required by the OS. If you utilize the entire 1.75 Gb for your databases, you're leaving .25 Gb (250 Mb) for the OS to operate. 250 Mb should be MORE than enough but just something to keep in mind for future reference.

    If you're concerned with performance, move this configuration off of the Xeon box. With an Intel based system, you're performance will never be as good as it will be on any Unix system (HP, Sun, AIX, etc).

bsidba_at_my-deja.com wrote:

> How many Oracle instances can I run on one server and still have good
> performance and reliability? Each instance will only have about 200MB
> to 300MB of data and about 10 to 20 users. The server will be a dual
> 933MHz Pentium III Zeon with 2GB of memory running Oracle 8.1.7 SE on
> Red Hat Linux 6.2. I was hoping I could run 20 to 25 instances. Is
> this out of the question? I have looked through the forums and have
> been unable to find a similar question and I was hoping that someone
> had experience with this many instances on one server. Your input will
> be greatly appreciated.
>
> Thank you
>
> Sent via Deja.com
> http://www.deja.com/
  Received on Thu Jan 18 2001 - 13:59:23 CST