James's Blog

Oracle: DBWn or DB Slaves

To determine whether to use multiple DBWn processes or database slaves, follow these guidelines:

1) For write intensive applications that also have a large data buffer cache (100,000 and up), configure DB_WRITER_PROCESSES

2) For applications that are not write intensive and run on operating systems that support asynchronous I/O, configure DBWR_IO_SLAVES

3) If the operating system does not support asnychronous I/O, use DBWR_IO_SLAVES

4) If your server only has one CPU, use DBWR_IO_SLAVES, DBWR processes are CPU intensive

posted by James Pei @ 2:10 PM