Re: Pro and Cons of multiple instances on NT

From: jhy <jhy_at_earthling.net>
Date: Thu, 15 Apr 1999 16:58:25 -0400
Message-ID: <7f5jtm$bba$1@bgtnsc03.worldnet.att.net>

PRO multiple instances:

Can tune each instance separately.
Can startup/shutdown/backup instances independently. Can easily move to separate servers later. Security is simplified (maybe).

CONS: Somewhat more system overhead (more memory, more processes). User maintenance (may have to add the same users to separate DBs).

My 2 cents.

Matthias Greß wrote in message <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
>--
>Matthias.Gresz_at_Privat.Post.de
>
>640 K ought to be enough for anyone.
>B.Gates 1980
>
Received on Thu Apr 15 1999 - 15:58:25 CDT