Re: Running mts on Oracle 8 onNT 4.0 sp4?

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 Mon Oct 25 1999 - 18:00:38 CDT