查看重做日志缓冲区大小

select 'V$PARAMETRER' "View name",name,
to_number(value,'9999999')  "Value"
from v$parameter
where name='log_buffer'
UNION
select 'V$SGASTAT' "View name", name,bytes
from v$sgastat
where name='log_buffer';