RE: different stats in sga..

<SPAN
class=807213810-14082001>Sharma:

<SPAN
class=807213810-14082001>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   

  <FONT
  face=Tahoma size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com] On Behalf Of Saurabh SharmaSent:   Tuesday, August 14, 2001 6:46 AMTo: Multiple recipients of list   ORACLE-LSubject: 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
 

  <A
  href="mailto:saurabh00pc_at_yahoo.com">saurabh00pc_at_yahoo.com<A   href="http://www.geocities.com/saurabh00pc/stride.html">http://www.geocities.com/saurabh00pc/stride.html Received on Tue Aug 14 2001 - 05:43:34 CDT