Obviously, in terms of transactions, number of bytes, he is doing nothing.
Either that workstation is smoking, or various instances don't do anything.
Hopefully the instances are not interconnected, but probably they are.
--
Sybrand Bakker, Oracle DBA
Paul Bennett <bennett_at_cc.gatech.edu> wrote in message
news:386E859A.7EEEFEA_at_cc.gatech.edu...
> 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 Sun Jan 02 2000 - 15:45:22 CST
