Thanks, Ross,
It may well be as you said, because Oracle Corporation thinks grouping all
Oracle "processes" into one OS process makes it run faster on NT. But I'd like
to see some kind of official answer from Oracle. Multithreaded Oracle.exe has
its own problem. For example, if one thread breaks, the entire process hangs or
dies. It probably makes sense to bundle all essential background "processes"
into one process because if one of them dies, it's meaningless to have all the
others continue running. But server "processes" running on behalf of user
programs as well as non-essential Oracle background "processes" are also part
of oracle.exe, aren't they? Wouldn't Oracle make a decision to favor stability
over performance, in view of the generally accepted instability of NT?
BTW, NT also supports shared memory and of course context switches but may be
inferior to the counterparts on UNIX (I don't know).
I made a mistake in my previous message saying "Oracle on NT runs as one
thread". I meant "one process".
Yong Huang
[EMAIL PROTECTED]
you wrote:
Oracle on NT runs as
ONE PROCESS
with
MULTIPLE THREADS
for performance reasons (no more
need for shared memory....context switches
are a LOT less expensive, etc.)
-----Original Message-----
Sent: Friday, February 02, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Hi, Mark,
Async I/O is available on Windows, at least NT. It's not an easy
topic. If you think you already know enough about operating
systems in general, I suggest you read David Solomon's "Inside
WindowsNT". For a lab test, launch Performance Monitor on your
NT box and look at the counters for Cache.
I'm not sure by "single thread management" whether you mean NT can't
have multiple processes or Oracle on NT runs as one thread. The
former is obviously wrong. The latter is a design issue inside
Oracle Corporation and the question as to why was asked on this
forum before without an answer (without an answer I can remember,
that is).
Yong Huang
[EMAIL PROTECTED]
__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: yong huang
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
