Re: Maximum Oracle instances on a Server?

We run separate servers for DSS and OLTP, with multiple instances on each server (up to 15) with multiple applications (schemas) per instance( 5 - 10). We are running on Sun 4500's with multiple CPU's and SAN storage.

This configuration has worked well in the past but recently we have run into situations where we needed to do "emergency maintenance" on one of the schemas to restore the schema to the state before the users truncated the production tables thinking they waer test data. The application, from a vendor not home grown, has the test and production data in separate schemas but the application allows users to switch between prod and test at will.) We could not get the approval of the other application owners to take down the instance for the repairs. So the first group had to wait. This would not have been an issue if the application was in its own instance.

 This event (along with a number of others) has resulted in a project to determine the resource requirements to move all applications into their own instances. We may be looking at nearly 200 instances by the time we are through.

On Tue, 26 Feb 2002 13:23:45 -0800, "Gonzo" <idonthaveemail_at_notime.ever> 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 - 22:16:14 CST