Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pro and Cons of multiple instances on NT

Re: Pro and Cons of multiple instances on NT

From: Donna Gearing <donna.gearing_at_hydro.on.ca>
Date: Mon, 19 Apr 1999 14:50:12 -0400
Message-ID: <7fftof$44c$1@usenet.Hydro.ON.CA>


I currently run up to 7 instances on each of 3 NT servers and have no problem. I use 7.3.4 however, you will need to be careful with 7.3.3. This version on NT has memory leakage problems. I would upgrade if possible.

Donna

jhy wrote in message <7f5jtm$bba$1_at_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 Mon Apr 19 1999 - 13:50:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US