Re: Are 5 Ora 7.3.3 Instances on 1 NT Box a good practice ?

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_at_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_at_my-deja.com> wrote in message
> >news:839a8m$s46$1_at_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_at_my-deja.com
> >>
> >>
> >> Sent via Deja.com http://www.deja.com/
> >> Before you buy.
> >
> >
Received on Sat Jan 01 2000 - 16:53:23 CST