Xref: alice comp.databases.oracle.misc:50271
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!cam-news-hub1.bbnplanet.com!washdc3-snh1.gtei.net!news.gtei.net!paloalto-snr1.gtei.net.POSTED!not-for-mail
Message-ID: <386E859A.7EEEFEA@cc.gatech.edu>
From: Paul Bennett <bennett@cc.gatech.edu>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: Are 5 Ora 7.3.3 Instances on 1 NT Box a good practice ?
References: <839a8m$s46$1@nnrp1.deja.com> <945324597.3608.0.pluto.d4ee154e@news.demon.nl> <C9j64.447$3K5.89318@ratbert.tds.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 52
X-Trace: +4AzTcyF0PQgB3ybPjOmG6/lFEZ6RAbqzGQJarELJ99ZZ/asb9JSUpPGgu+GURGU88zhu3bNQbIM!KOQHAYko3cHGePrVrsmHbO8HXGdsi/M8ad6bsBp77OIWn0nDhN0ocg==
X-Complaints-To: abuse@gte.net
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
NNTP-Posting-Date: Sat, 01 Jan 2000 22:53:22 GMT
Distribution: world
Date: Sat, 01 Jan 2000 22:53:23 GMT

I am curious.  Why would you do this?  Why not run one instance?

-- Paul

Mike Morgan wrote:

> Actually it's all a matter of perpective and "user expectations".  We have
> 18 databases, whose average SGA is about 50MB, running on a single NT
> workstation (2 133 MHz processors, 1 GB RAM, 1GB pagefile) running Oracle
> 7.3.4 and, aside from the inevitable "queries from Hell", performance is not
> bad.  I wouldn't recommend this configuration for life-or-death real-time
> nuclear facilities but, in a pinch, most NT servers can handle 5 instances.
>
> Mike Morgan
>
> Sybrand Bakker wrote in message
> <945324597.3608.0.pluto.d4ee154e@news.demon.nl>...
> >No, No, No
> >The NT box will 100 percent most likely be unable to cope with the load,
> >and ALL instances will suffer from this.
> >In a 256M conf, 2 is maximum.
> >
> >Hth,
> >
> >--
> >Sybrand Bakker, Oracle DBA
> ><rock_cogar@my-deja.com> wrote in message
> >news:839a8m$s46$1@nnrp1.deja.com...
> >> Hi,
> >>
> >> I have been asked to help people at a "sister" company move a production
> >> Oracle 7.3.3 installation from a Denver NT server to an NT server in St.
> >> Louis.
> >>
> >> It turns out that there are 5 Oracle 7.3.3 instances on the source
> >> machine that each have the same single schema which is also the only
> >> non-system schema. Of course there are minor differences, extra "load"
> >> tables and different amounts of population in the "main" tables.
> >>
> >> QUESTION: Is having 5 Oracle 7.3.3 Instances on 1 NT Box a good practice
> >> ?
> >>
> >> Thanks,
> >> Rock Cogar
> >> Email:  rock_cogar@my-deja.com
> >>
> >>
> >> Sent via Deja.com http://www.deja.com/
> >> Before you buy.
> >
> >