Re: 5 instances = too much ???

You make some good points, but I'm not sure if the original poster was asking about technical limits or administrative issues. I don't think there are any technical limits to how many instances a box can support other than the usual capacity issues. From the administrative side, there are pros and cons. It depends on the criticality of the applications, the money they can spend on hardware, and the staff available to support the hardware and software. Here, we have apps where 1 instance per box is the right answer, some apps where many instances per box is perfectly acceptable.

"Daniel A. Morgan" wrote:
>
> I understand. But when the server goes down. All five instances go down. Which
> can put a company, or a department, out of business for hours or days.
>
> If your company grosses $40 million per year you lose the cost of a $100,000
> server every 24 hours you are out of business. I doubt there are too many
> companies using Oracle on $100,000 servers that don't make that much money
> annually. Tell your CFO to do the math.
>
> Daniel A. Morgan
>
> Joe Kazimierczyk wrote:
>
> > It's impossible to give a rule of thumb on this. It all
> > depends on the resources consumed by your instances vs what
> > your hardware can handle. 5 instances with 2Gb memory
> > sounds reasonable if your instances are not big hitters (I
> > don't know what 'rational' is - sorry).
> >
> > > I've never had a machine with more than 3 instances. Now we're thinking
> > > of going from 3 - 5 instances on a machine that has 2Gig memory. None of
> > > the databases are too big- mostly support for apps like rational.
> > >
> > > So- when do you hit the limit for instances ? Is there a rule of thumb ?
> > >
Received on Fri Apr 20 2001 - 06:40:33 CDT