Login  Register

Log buffer

Posted by big on Oct 22, 2021; 5:12am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Log-buffer-tp10361.html

Hi,
On 11.2.0.4 on AIX

I have:

SQL> show parameter log_buffer

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_buffer                           integer     10485760

But when I run:

SQL> show sga

Total System Global Area 2137886720 bytes
Fixed Size                  2248080 bytes
Variable Size            1157628528 bytes
Database Buffers          956301312 bytes
Redo Buffers               21708800 bytes

Why log_buffer  value is different from Redo Buffers value? Aren't they the same buffer?

Thanks