Max number of instances on sun E450

[mb]

Does anyone have any opinions on what the maximum number of instances on sun a E450 with 2gb of RAM should be. Im not sure how much the kernel parameters can be increased without causing problems.

Basically the sys admin is of the opinion that all the databases should be placed on one or two boxes as opposed to spread over 4 or 5 and running on the same box as application servers etc. This is a development environment.

[Edited by mb on 09-18-2001 at 06:38 AM]

[dknight]

It depends on the workload.

I run three instances on a Sun 450 with 1 GB. One of the instances is the recovery catalog. The other instances are used infrequently, but the performance is poor overall.

It is less work for your sysadmin to manage fewer machines, but perhaps you can do a phased migration to determine if your organization can function with diminished Oracle performance.

good luck.

[marist89]

Originally posted by dknight
It depends on the workload.

I agree. I run 6 development instance on a box smaller than a E450. They are really small development db's, but perform OK becuase they are hooked up to a Fibre array and the box has 2G of RAM.

[mb]

Thanks for the response.
What about 10-15 instances with a RAID5 A1000?

[pando]

It´s RAM that is important unless your databases are BIG?

[sambavan]

Originally posted by mb
Thanks for the response.
What about 10-15 instances with a RAID5 A1000?

I would consider this to be a bit too much of a load ...

Sam

[grjohnson]

I forsee a box being choked, and agree with PANDO. I mean 10 - 15 isntances, what are their SGA sizes, you might run out of RAM. I also depends on the type of databases running also. Are they CPU intensive? Will there be a lot of activiety on each instance?