Re: Instance vs Schema pro/cons

dana.stockler_at_hydro.com (baldo) wrote in message news:<b778fc84.0311270213.cb0a26e_at_posting.google.com>...
> joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0311261315.662d7ce_at_posting.google.com>...
> > Marc Eggenberger <marc.eggenberger_removeME_at_itc.alstom.com> wrote in message news:<MPG.1a2ee28e17cdcf229896dc_at_iww.cacti.ch.alstom.com>...
>
> [snip]
>
> > Unless you are on Windows, then you pretty much have to do one
> > instance/one box (or less). You can do more, but it inevitably winds
> > up a PITA.
>
> Just my 2 cents.
>
> I run four production instances on one windows server and six
> test instances on another. Works well for me. Not at all a PITA.

I'm glad _someone_ has it working well! :-)

Just curious - how much mem, how big SGA's, have you upgraded any homes, do you use automatic service startup?

>
> One instance services one application, not because I think that
> is the best way, but because the apps more or less demand it.

Well, I would call that a PITA! :-)

jg

--
@home.com is bogus.
I've got cyanoacrilate on my fingers!