Re: Instance vs Schema pro/cons

Marc Eggenberger wrote:

> Hi there.
>
> I need some opinions ...
>
> Its about if its better to have one oracle instace and several
> applications in schemas or if I can be better to have several instances
> on one server.
>
> I would normally go the one instance / everything else in schemas way
> because of the overhead (having multiple sga's etc)
>
> Multiple instances are more independant. So if you need different
> settings (that are instance wide). Or maybe to seperate customers more.
>
> Do you have other pros and cons?

I always prefer one instance per server. There are valid reasons not to. But they are few and far between.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)