RE: OT RE: Database writer

 "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: PierceED_at_csus.edu

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_at_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).