Re: Pro and Cons of multiple instances on NT

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 15 Apr 1999 11:03:01 +0200
Message-ID: <3715AB44.98D2F29E@vnl.nl>

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.

You can remotelty start and stop instances, even reboot the machine. --
Met vriendelijke groet,
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 Thu Apr 15 1999 - 04:03:01 CDT