Re: DBA Tip of the Month

So what's this got to do with multiple log writers?

In article <O8Oz4.44$a5.26181_at_news.abs.net>, "Cam White" <cwhite_at_revealnet.com> wrote:
> 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.
> =========================================
> NEWS FROM REVEALNET
> 1. Embarcadero Technologies Integrates RevealNet Knowledge Bases
> 2. RevealNet Introduces the "Active PL/SQL Knowledge Base"
> details at http://www.revealnet.com
>
> Enjoy the Pipelines!
>
> Cam White
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 00:00:00 CST