Re: Maximum Oracle instances on a Server?

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 26 Feb 2002 21:23:00 GMT
Message-ID: <3C7BFCB3.9A23C356@ci.seattle.wa.us>

I would say one. Not that you can't put more on ... but I've never understood the reason for creating another instance with its own SGA when you can just as easily create another schema with its own tablespaces.

Now how many are possible? Depends on what you are doing with them.

Daniel Morgan

Gonzo wrote:

> What is the maximum "SAFE" production instances that one should run on an
> Oracle 8.17 Server
>
> Each instance has 2-5 users, 200 entered transactions/day.
> Varied Queries & Reads.
>
> 1. For a Dual CPU, 1GB, Dell Windows 2000 Server with a mirrored set of 2
> striped drives each?
>
> 2. For a Dual or Quad CPU, 4GB, SUN Solaris Server with a mirrored set of 3
> striped drives each?
Received on Tue Feb 26 2002 - 15:23:00 CST