Re: How many Oracle 9i Instances can I create on the P650 AIX?

DBA wrote:

> I'm trying to plan how many instances can I create on the P650 Server
> without loosing great deal of performance and encounter a lot of
> swapping:
>
> Server Specs:
>
> OS: AIX 5.1
> Nr of CPUs: 4
> Memory: 4GB
> Virtual Memory: 8GB
> Disk Space: 400GB
>
> Database Specs:
>
> Oracle 9i (9.2.0.1)
> Max user: 50
> Concurrent users: 20 - 30
> The size of an instance around: 4GB
> The size of SGA: 500 - 600 MB
>
> Please advise.
>
> Thank you
>
> Marcel

You are asking the wrong question so any integer answer is meaningless.

Why are you installing 9.2.0.1? At a minimum you should be installing 9.2.0.5.

Why do you think you need more than one instance?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)