Show TOC

LOG_BUFFER (Oracle)Locate this document in the navigation structure

 LOG_BUFFER (Oracle)

This value specifies the size in bytes of the redo log buffer in the SGA. The redo log buffer is used by Oracle to store information about changes made to the database (redo entries). This information is needed for recovery purposes. The information in the redo log buffer is written to the online redo log files by the LGWR process.

The default setting for this parameter for SAP systems is 327680. This value is sufficient for most applications. If modifying this value, note that it must be set to a multiple of db_block_size.(DB_BLOCK_SIZE (Oracle)).

See also:

Redo Log Buffer (Oracle)

Monitoring the Redo Log Buffer (Oracle)