Re: Number of instances per Oracle engine

From the original question: if a database is defined to be a collection of tables into a schema, then you can consolidate all of the databases under one instance in one machine. A database, as just defined, can be created under one oracle user.

Naturally, each database's performance will suffer unless the machine has at least 5 times the resources and speed.

> yeowhin_at_singnet.com.sg wrote in message
> <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 Fri Jan 05 2001 - 19:45:23 CST