Login  Register

Re: Log buffer

Posted by ErmanArslansOracleBlog on Oct 22, 2021; 7:00am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Log-buffer-tp10361p10362.html

LOG_BUFFER specifies the amount of memory (in bytes) that Oracle uses when buffering redo entries to a redo log file.
Redo Buffers that you see in show sga output may be different (higher) the value of LOG_BUFFER and this is normal.
We have extra pages there.. for instance the guard pages for protecting the log buffer..

Check-> Init.ora Parameter "LOG_BUFFER" Reference Note (Doc ID 30753.1)
There you will see the following ->

he memory set aside for the log buffer may also be surrounded by guard pages to help protect the redo buffer, hence the size of Redo Buffers shown at instance startup may differ from the value of LOG_BUFFER set in the init.ora file.