Re: Maximum memory on NT

Yes, MTS helps cut down the RAM hogging, but there are some negative issues with it especially with 10,000 connections. See Oracle documentation and performance tuning.

Stilian

Denny Koovakattu wrote:
>
> You could use MTS on Unix to cut down on your memory requirements. MTS is not
> available on NT for Oracle7. With Oracle8 you get MTS on both NT and Unix.
>
> Denny
>
> In article <36F6CD2C.BEE239C0_at_vtls.com>,
> Stilian Elenkov <elenkovs_at_vtls.com> wrote:
> >
> >
> > "Christopher M. Day" wrote:
> > >
> > > Jim,
> > >
> > > I remember this one being a major difference between Oracle7 on NT vs.
> > > Oracle7 on Unix (i.e. NT max users = 1024, UNIX = 10s of thousands ..) -
> > > Is this overcome in Oracle8 ?
> >
> > A user session to Oracle takes much less space under NT than for UNIX
> > simply because of the thread vs process architecture.
> > Lets assume a session on NT takes about 2M (since threading allows for
> > shared memory segments). The same sessions for UNIX would be ~ 10 M each
> > (because they are independent processes) so NT reaches its 2G limit with
> > 1024 connections. Assuming 10,000 connections (Your minimum claim for
> > UNIX) - UNIX will need 97G of memory. I would rather have 12 2G NT boxes
> > that are in a cluster - fault tolerant, faster and 10s of thousands of $
> > cheaper that the UNIX box that does the same job.
> >
> > Stilian
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Mar 23 1999 - 14:33:29 CST