From yong321@yahoo.com Sat, 03 Feb 2001 22:20:01 -0800 From: yong huang Date: Sat, 03 Feb 2001 22:20:01 -0800 Subject: RE: Async I/O on Windows Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 yong321@yahoo.com 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 yong321@yahoo.com __________________________________________________ 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: yong321@yahoo.com 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: ListGuru@fatcity.com (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).