Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Default value for log_buffer parameter

Default value for log_buffer parameter

From: David Hollenberg <dhollen_at_marten.isi.edu>
Date: 26 Oct 2005 13:29:54 -0700
Message-ID: <djop02$142@marten.isi.edu>

Using Oracle 10.2.0.1.0 on Solaris 9.
Value for parameter sga_target = 1G. I let the value for parameter log_buffer default.

SQL> show parameter log_buffer

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_buffer                           integer     6203392

SQL> select name, value, isdefault from v$parameter where name = 'log_buffer';

NAME                 VALUE                ISDEFAULT
-------------------- -------------------- ---------
log_buffer           6203392              TRUE

Documentation says that redo log buffer size is controlled manually (not part of automatic sizing) and has a default value of "512 KB or 128 KB * CPU_COUNT, whichever is greater". Machine has 4 CPUs, so log buffer size should be 512 KB. Documentation bug or code bug?

-- 

David Hollenberg    dhollen@NOmosisSPAM.org    http://www.mosis.org/
MOSIS Service                            Voice 310-448-8704
Information Sciences Institute           FAX   310-823-5624
Received on Wed Oct 26 2005 - 15:29:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US