Re: Number of instances per Oracle engine

If you value performance, you would be utterly mad to even contemplate something like this. Multiple Instances and Databases on the one box aren't a problem in themselves, but they compete with each other for resources. Assuming you throw enough RAM at the problem, 5 Instances shouldn't be a worry (I hope you have at least 5 processors), but multiple Databases, simultaneously accessed, means competition for disk reads and writes. Sure, you can minimise this by throwing RAID and God knows what else at the problem, but it seems daft to be doing so to avoid a problem that didn't originally exist.

Of course, it will all come down to how high-end your new Server will be, and how low-end your existing boxes are ... I guess the balance could come out on the side of consolidation. But the general proposition for good performance is (1) don't run it on NT and (2) one database per box.

Regards
HJR <yeowhin_at_singnet.com.sg> wrote in message news:3a52ca1e.16842639_at_news.singnet.com.sg...
> Hi,
>
> Can anyone advise on the max number of instances that 1 oracle engine
> can support. Currently, we have 5 databases (in 5 physical unix boxes)
> belonging to 5 different projects and we are thinking of consolidating
> all the 5 databases into 1 high end server. Is there any implications
> for doing this? Is it recommended?
>
> Thanks in advance
>
> Rgds,
> YH
Received on Thu Jan 04 2001 - 00:37:21 CST