SQL>
SQL> select Name,
2 Value
3 from V$PARAMETER
4 where Name = 'log_buffer';
NAME
------------------------------------------------------
VALUE
------------------------------------------------------
log_buffer
2859008
1 row selected.
SQL>
SQL>