Redo log buffer size

689302

We noticed something curious in our database. The parameter file specifies the LOG_BUFFER to be 1048576, but if I say "show parameter log_buffer," the value is set to 14282752! Is there another setting in Oracle that would override the size of the redo log buffer?

Sam

591186

assuming your oracle verision is 10g,
Take a look at the following metalink notes:

*604351.1 -ORACLE CALCULATION OF LOG_BUFFER SIZE IN 10G*
*373018.1LOG_BUFFER Differs from the Value Set in the spfile or pfile*

289595

Also at:

http://space.itpub.net/html/91/7695891-66388.html