Re: log_buffer sizing

serge wrote:
>
> select 'V$PARAMETER' "TABLE NAME", name,
> to_number(value, '9999999') "VALUE"
> from v$parameter
> where name = 'log_buffer'
> UNION
> select 'V$SGASTAT' "TABLE NAME", name, bytes
> from v$sgastat
> where name='log_buffer'
>
> hi everyone. What is the purpose of this query? Is it comparing the
> value of the log_buffer from memory(v$parameter) to the value of the
> log_buffer is set to in the initialization file(v$sgastat)?
> why is it that with certain dbs these values are the same and with
> other dbs they vary?

The log buffer is often (always?) protected by some pages either side, hence the size in the v$sgastat is normally larger than your parameter.

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------