I run MTS for a different reason: we have users who query infrequently, but
need very large sort/hash areas to get their queries run quickly. MTS allows
these users to share a smaller number of processes (and thus a smaller
number of sort areas) so the server doesn't waste so much memory.
Pete Sharman <psharman_at_us.oracle.com> wrote in message
news:3814E116.54A1CA03_at_us.oracle.com...
> David
>
> It would be best if you told us WHICH MTS you mean. I assume from the
> email you mean Multi-Threaded Server, not Microsoft Transaction Server,
> so the rest of my answer is predicated on that basis.
>
> All releases of Oracle8 allow you to run MTS on NT, so from 8.0 up you
> can do it. Would you need to in the majority of cases? No, because the
> OS is already multi-threaded. When I asked the developers why this was
> added, I was told we had clients who wanted to have 4000+ users on a
> single NT box, and that's why it was done. Of course, I'd have to
> question the wisdom (if not the sanity) of such a request, but that's my
> personal viewpoint, not Oracle's!
>
> The only situations I can think of that you'd really be interested in
> using MTS on NT is when you want to run Connection Manager. The
> Connection Manager architecture is based on MTS, and it's a requirement
> for running Connection Manager.
>
> HTH.
>
> Pete
>
> David Spaisman wrote:
>
> > Hello:
> >
> > Recently I saw some information that MTS could be
> > made to run on Oracle 8 on NT.
> >
> > I am running an application on Oracle 8.0.4 on NT
> > 4.0 sp 4. Currently the application has about 120
> > users. In the past I have run MTS on a Oracle 7.3
> > application on HP_UX.
> >
> > Since NT is multi-threaded, what would MTS provide
> > for the Oracle application? Under what
> > circumstances would I use MTS and when not?
> >
> > Does any one use MTS for an Oracle 8 application on
> > NT now? Would it provide any benefit on an NT 4, sp 4
> > server to an Oracle 8.0.4 application?
> >
> > Any expereinces you can share would be invaluable.
> >
> > Any information which you can provide would be
> > greatly appreciated. Thanks.
> >
> > David Spaisman
>
Received on Tue Oct 26 1999 - 17:50:21 CDT
