Re: multi threaded server on NT?

Phil Herring <revdoc_at_uow.edu.au> writes:

>In article <6hq98u$310$1_at_sky.net> Dan Norris, dann_at_sky.net writes:
>>I have read oracle docs that claim that MTS was not supported on oracle7
>>for NT, but has been added in oracle8 on NT. Who's right?

>Oracle7 answer: MTS was a hack to allow the same threaded software to work
>under any Unix (because not all Unixes support threading directly). NT has
>support for threads built in, so Oracle for NT was written to be
>multithreaded using that native support, and as such, "MTS" doesn't exist
>under NT. However, it *is* multithreaded.

>I don't know about Oracle8.

True--Oracle on NT is multithreaded, but a new thread is spawned for each connection to the database. MTS is not available on Oracle7 for NT according to all the Oracle docs I've read. However, that is one of the new features offered with Oracle8 for NT. MTS has been available on other platforms in most Oracle7 (and Oracle8) versions.

So, while the Oracle architecture on NT is "multi-threaded," there are no shared server processes by default.

Dan

>---------------------------------------------------------------------------
>Copyright 1998 Phil Herring. This article may not be reproduced for profit.
>---------------------------------------------------------------------------
Received on Wed Apr 29 1998 - 17:32:20 CDT