Can we change log_buffer parameter online e.g. when all users are working..
568492Mar 23 2007 — edited Mar 23 2007Hi,
Can we change log_buffer parameter online e.g. when all users are working.. ???
What is relation between redo buffer in sga and log_buffer parameter ?
SQL> show sga
Total System Global Area 3758096384 bytes
Fixed Size 1983152 bytes
Variable Size 553655632 bytes
Database Buffers 3187671040 bytes
Redo Buffers 14786560 bytes
SQL>
SQL> show parameter log_buffer
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_buffer integer 14338048
SQL>
SQL>
If the log_buffer parameter is 14 MB then why redo buffer is no as same size e.g.
14 MB
SSM