Key points about setting a reasonable log buffer size

Key points about setting a reasonable log buffer size

1, default size MAX (0.5 M, (128 K * number of cpus ))

2, On most systems, sizing the log buffer larger than 1 M does not provide any

Performance benefit. It merely uses extra memory.

3. View 'redo buffer allocation retries' statistics

Select name, VALUE

From v $ SYSSTAT

Where name = 'redo buffer allocation retries ';

The value of redo buffer allocation retries shoshould be near zero over an interval. If The difference is too large, you need to set The log_buffer size.

4. log buffer space wait even if this wait event is one of the main events, the log buffer size needs to be adjusted.

---- Modification of the log_buffer parameter takes effect only after the server is restarted.

Show parameter log_buffer

Alter system set log_buffer = xxx scope = spfile;

Difference between Buffer cache and page cache

Performance of Buffer cache in Linux

Usage of cache and buffer in Linux