Log_buffer & Redo Buffer
We are using oracle 11.2.0.1 on IBM AIX
After showing Redo Buffer size we are wondering because the size of the redo buffer is different to the configured parameter log_buffer.
SYS@DPTEST>show sga
Total System Global Area 3724607488 bytes
Fixed Size 2212304 bytes
Variable Size 2634026544 bytes
Database Buffers 1056964608 bytes
Redo Buffers 31404032 bytes
log_buffer integer
14237696
Question, is this normal? We are wondering because on machine with less 32 GB SGA the value is most the same between log_buffer and redo buffer.
Hope of anyone can help,
Rou
After showing Redo Buffer size we are wondering because the size of the redo buffer is different to the configured parameter log_buffer.
SYS@DPTEST>show sga
Total System Global Area 3724607488 bytes
Fixed Size 2212304 bytes
Variable Size 2634026544 bytes
Database Buffers 1056964608 bytes
Redo Buffers 31404032 bytes
log_buffer integer
14237696
Question, is this normal? We are wondering because on machine with less 32 GB SGA the value is most the same between log_buffer and redo buffer.
Hope of anyone can help,
Rou
0