DOC BUG: DB_WRITER_PROCESSES IS INCORRECTLY LISTED AS NOT SUPPORT

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 26 Jun 2001 00:35:56 -0700
Message-ID: <F001.00337B3C.20010626000020@fatcity.com>

I thought this might be of interest to people as there have been a number of discussions as to whether multiple DB writers are supported on NT.

Regards,
Bruce

Bug No. 1839458
Filed 19-JUN-2001 Updated 22-JUN-2001
Product Oracle Server - Enterprise Edition V7 Product Version 8.1 Platform Intel Windows NT Platform Version 4.0 RDBMS Version 8.1 Affects Platforms Port-Specific Priority Minimal Loss of Service Status Doc Bug (Response/Resolution) Base Bug N/A Fixed in Product Version No Data

Problem statement:

DOC BUG: DB_WRITER_PROCESSES IS INCORRECTLY LISTED AS NOT SUPPORTED ON NT

---

---

• 06/19/01 03:45 am *** Bug 925955 was logged and states that DB_WRITER_PROCESSES are not supported on NT. Starting with 8.1.5 the documentation was also updated to include this.
  .
  Unfortunately this information is NOT correct. DB_WRITER_PROCESSES *is* supported on Windows NT and Windows 2000 and has been supported since 8.0.
  .
  Multiple DB_WRITER_PROCESSES is mainly used to simulate asynchronous I/O when the OS does not support it. Since NT and Windows 2K use asynch I/O by default, using multiple db writer processes may not necessarily improve performance. In cases where the main performance bottleneck is that DBWR cannot keep up with the work load, then increasing the number of DB_WRITER_PROCESSES may improve performance.
  .
  When increasing DB_WRITER_PROCESSES it may also be necessary to increase DB_BLOCK_LRU_LATCHES as each DBWR process requires an LRU latch.
  .
  
• 06/19/01 06:20 am *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: Bruce.Reardon_at_comalco.riotinto.com.au

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). Received on Tue Jun 26 2001 - 02:35:56 CDT