RE: different stats in sga..

[Jon Walthour]

Title: Message

Sharma: Some of this extra memory is taken up with the redo log guard pages. Guard pages are one memory protection unit in size and are there to prevent Oracle software bugs or hackers from corrupting the log buffer. Another portion of the memory results from a minimum size for the log buffer of 4 * db_block_size. This rounding up is reflected in v$sga, but not in v$sgastat. Jon Walthour -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Saurabh Sharma Sent: Tuesday, August 14, 2001 6:46 AM To: Multiple recipients of list ORACLE-L Subject: different stats in sga.. Hi all,   i've changed the log_buffer parameter in my init file to a little higher value( say from 32768 to 40960) and bounced my DB but sga shows the redo buffer to 73728 (no change in pre value) while looking into v$sgastat, it says log_buffers = 65536 (still no change in pre value)   why is this so, i'm getting diff values.. can anyone explain. thanks Saurabh Sharma   [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html