| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> DBA Tip of the Month
Join the DBA Pipeline - a free community for Oracle DBAs worldwide.
Participate in technical discussions, download white papers, and subscribe
to the monthly newsletter. All of the Pipeline services have high quality
technical content and are completely free. The Pipelines are hosted ny
Oracle authors Mike Ault & Steven Feuerstein, and sponsored by RevealNet.
Pipeline Communities: http://www.revealnet.com/pipeline.htm
Current Pipeline Newsletter:
http://www.revealnet.com/newsletter/newsletter_0300.htm
March's Tip of the Month
Configuring Oracle8.1 with Multiple LGWR's
Using the DB_WRITER_PROCESSES initialization parameter, you can create multiple database writer processes (from DBW0 to DBW9). These may be useful for high-end systems such as NUMA machines and SMP systems that have a large number of CPUs.
These background processes are not the same as the I/O server processes (set with DBWR_IO_SLAVES); the latter can die without the instance failing. You cannot concurrently run I/O server processes and multiple DBWn processes on the same system.
If you have a large number of datafiles or are in a high OLTP environment, you should always have the CHECKPOINT_PROCESS initialization parameter set to TRUE. This setting enables the CKPT process, ensuring that during a checkpoint LGWR keeps on writing redo information, while the CKPT process updates the datafile headers.
Enjoy the Pipelines!
Cam White Received on Wed Mar 15 2000 - 09:44:06 CST
 |
 |