Re: Pro and Cons of multiple instances on NT

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 16 Apr 1999 12:31:57 +0200
Message-ID: <3717119D.3C661CFE@vnl.nl>

I would say 'jhy' answered that quite well. One thing to add: when there's a lot of data redundant in the applications, I might consider one instance: so a client relations and sales app would probably
end up in one instance, but a client relations and manufacturing would probably not.
Note the probably's!

Boils down to: it's up to you, consider all things pointed out, and I fully agree with
the points brought forward by jhy

Matthias Greß wrote:

> 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

--
Gruess,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046

Received on Fri Apr 16 1999 - 05:31:57 CDT