Re: Running mts on Oracle 8 onNT 4.0 sp4?

OK, that's valid. It seems you can wear the overhead of the circuit in MTS, which in any case is a lot better in Oracle8 than it was in 7.

Pete

"Kevin P. Fleming" wrote:

> 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 - 18:42:50 CDT