"The Oracle DBA's Guide to NT"
Guy Harrison
Published Spring 1998:
http://www.oreview.com/9805harr.htm
( linked from: http://home.mira.net/~gharriso )
--- excerpts ---
...
The architecture of Oracle in an NT environment is somewhat
different [than Unix/etc.] (see Figure 2). Oracle takes advantage
of NT's strong support for threads. In almost all operating
systems, a process is forbidden to access memory belonging to
another process. Threads belonging to the same process, however,
share a common memory address space and are therefore able to
share memory easily.
...
On NT, the Oracle instance is implemented as a single NT process.
This process includes threads that implement each of the tasks
required for the instance. Therefore, there is a thread for each
of the background and server tasks plus a two-thread overhead.
Because each thread shares the same memory space, there is no need
to implement the SGA in shared memory; if you implement the SGA
within the instance's process memory, it is available to all
threads within the process.
...
Performance tuning principles for Oracle in an NT environment are
fundamentally the same principles that govern Unix tuning.
...
There are, however, a few NT-specific considerations:
Windows NT supports asynchronous I/O; configuring multiple db
writers is not required.
...
--- end ---
regards,
ep
On 6 Jun 2001, at 21:20, C.S.Venkata Subramanian wrote:
> Dear All,I chked out with Oracle Support. they say that multiple
> db writers in NT is of no use. Since NT will take care of writes.
> Pl refer to "This has been documented as not applicable parameter
> in the Oracle8i Reference Manual of 8.1.6 Release for Windows NT -
> Appendix B."
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
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).
