Re: log_buffer, redo buffers, and show sga

From: srivenu <srivenu_at_hotmail.com>
Date: 27 Feb 2004 04:28:14 -0800
Message-ID: <1a68177.0402270428.3b30a537@posting.google.com>

The 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.
You may like to refer this note by Steve Adams http://www.ixora.com.au/notes/log_buffer_guard_pages.htm

Also the default size for log_buffer is set to 4 times the maximum database block size for the host operating system (in your case NT's) . In Oracle8 this is also an enforced minimum.

regards
Srivenu Received on Fri Feb 27 2004 - 06:28:14 CST