Re: DB_WRITERS set > 1

julienr_at_ncr.disa.mil wrote:
>
> The docs indicate that DB_WRITERS set greater than 1 causes Oracle to proc
> child writer processes. I am running a Sun Sparc20 with 4 processors using Oracle 7.3.2,
> have set DB_WRITERS to 4 and bounced the instance. I checked the DB_WRITER count
> via svrmgr once the db was restarted and found it to be 4, however a ps of the current processes
> revealed just the single DBWR-- no writer child processes (eg. db002...). Is this unsupported under
> UNIX (solaris 2.4), which seems unlikely, or are these child processes launched as needed?
>
> Any experience with this?
>
> Randy
> Randy,

The number of DBWR processes will always be one regardless of your init.ora setting if you've got async I/O enabled, which is the default on Solaris platforms.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.