Re: 5 instances = too much ???

Is it possible? Yes.

Is it sensible? IM(not so)HO No.

Why create multiple instances? Why not just add some more tablespaces to your existing instance and use different schema names?

I see this kind of thing all the time and I see no justification for have multiple copies of the data dictionary. Multiple copies of each and every process. Multiple listeners. And on and on and on. It buys you absolutely nothing but maintenance headaches.

My rule of thumb is one instance per machine. And when the financial types start their whining about the cost of hardware I remind them what it costs when they have to pay me to come in on a weekend and clean up the mess not to mention of value of lost productivity. The last CFO that didn't listen to reason got a lesson in reality. When the machine crashed I phoned him and told him it was his responsibility to notify the company's CEO. And that if he didn't I would forward all of his emails refusing our request for more servers because it would save the company money.

Yes he notified the CEO. And yes we got our servers in less than a month.

Daniel A. Morgan

Feldman Roger wrote:

> Oracle People:
>
> 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 ?
>
> Thanks,
>
> Roger
Received on Thu Apr 19 2001 - 00:50:54 CDT