Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Default value for log_buffer parameter
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-5624Received on Wed Oct 26 2005 - 15:29:54 CDT
![]() |
![]() |