Re: mts on NT 8.0.4?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 26 Apr 1999 09:37:43 -0700
Message-ID: <37249657.90AB8189@us.oracle.com>

David

I'm assuming that the MTS you're asking about is Oracle's Multi Threaded Server architecture, not MIcrosoft Transaction Server.

Yes, you can use MTS with Oracle8 on NT, not with Oracle7. Reasons for using it:

Not enough memory for the number of users, so you want to reduce the number of server processes, thus reducing total memory usage.
Because you want to use either Connection Manager (likely) or Connection Pooling (less likely). Both these products rely on the kernel code that supports MTS.

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 server to an Oracle
> 8.0.4 application?
>
> Any information which you can provide would be
>
> greatly appreciated. Thanks.
>
> David Spaisman

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon Apr 26 1999 - 11:37:43 CDT