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?
Received on Fri Oct 20 2006 - 19:35:58 CDT
