Re: Pro and Cons of multiple instances on NT

Frank van Bortel wrote:
>
> Marcus N Hofer wrote:
>
> > Hi Matthias,
> >
> > Matthias Greß schrieb in Nachricht <3714C6EB.58F6CECE_at_privat.post.de>...
> > >Hi,
> > >
> > >I've to administrate a small Oracle server (Oracle 7.3.3 on NT4sp3)
> > >(2-3GB) where new applications will be installed. Now we have to decide
> > >wether to create new instances for these applications or 'just' to
> > >adjust the SGA-parameters of the current instance to fit the additional
> > >needs.
> > >Any comments welcomed.
> > >Thanks
> > >Matthias
> >
> > IMHO if it is viable rely on one instance and adjust the SGA regarding
> > the most performance critical application. Multiple instance databases
> > are more difficult to administrate.
>
> ? Just as difficult as one!
> Because of the different requirements, I'd opt for multiple instances!
> Especially when development and production instances are running off
> one machine. NT is one of the easiest platforms to maintain instances,
> especially when you use the option pack for NT.
>

Production and development/testing will be performed on distinct servers. The question is:

use distinct database for each application or merge the data into one database?

Thanks for your responses so far,
Matthias
--
Matthias.Gresz_at_Privat.Post.de

640 K ought to be enough for anyone.
B.Gates 1980 Received on Thu Apr 15 1999 - 11:15:03 CDT