Oracle Tips by Burleson

Tuning LGWR 

The LGWR process is tuned by sizing the LOG_BUFFER parameter and by starting the checkpoint process on non-Oracle8 versions of Oracle. An additional option on Oracle8 is the LGWR_IO_SLAVES parameter, which is are manually configured under Oracle8.0 and automatically configured under Oracle8.1 if DBWR_IO_SLAVES is set to greater than 1 or Oracle parallel query is enabled. The default value for this parameter is 4.      

Under Oracle8.1, a feature called incremental checkpointing was provided. By setting the DB_BLOCK_MAX_DIRTY_TARGET initialization parameter, you limit the number of blocks the recovery process must read from disk during a recovery process. DB_BLOCK_MAX_DIRTY setpoints affect the speed of recovery and may have a detrimental affect on normal runtime performance.

See Code Depot

www.oracle-script.com