Integer 

Static 

1 

1 to 10 

DB_WRITER_PROCESSES is useful for systems that modify data heavily. It specifies the initial number of database writer processes for an instance. If you increase the value from the default of 1, you should adjust the DB_BLOCK_LRU_LATCHES parameter so that each database writer process (DBWn) has the same lumber of latches (LRU buffer lists).  

Note: If you set the DBWR_IO_SLAVES parameter, Oracle uses only one database writer process, regardless of the setting for DB_WRITER_PROCESSES. 

See Also:

• Oracle8i Concepts for more information on the database writer processes.

• Oracle8i Designing and Tuning for Performance for information on setting the DBWn parameters.