14MB for log buffer appears to be the default I've seen when creating a database through dbca. Julio Quijada -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark Sent: Thursday, May 28, 2009 9:50 AM To: ujang.jaenudin@xxxxxxxxx; Oracle Discussion List Subject: RE: log_buffer 10gr2 Ok, first, take a step back. What is motivating you to look at log_buffer in the first place? Why do you think it needs to be adjusted? Starting w/ 10g, the log_buffer is maintained by Oracle, and should not need to be adjusted. (See MetaLink Doc ID 351857.1.) What is the current value of _log_io_size? Why do you think you need to adjust it? Main question: What is it that is leading you to believe that log_buffer and _log_io_size need to be adjusted? -Mark -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ujang Jaenudin Sent: Thursday, May 28, 2009 6:14 AM To: Oracle Discussion List Subject: log_buffer 10gr2 dear all, I have 10.2.0.3 on solaris sparc, when trying to decrease log_buffer, it could not be done. always keep 14MB, sga is 3.5GB I want to decrease it to 1MB according to metalink note. 351857.1 it is expected behavior. so, is it save to change _log_io_size to 1MB ? -- thanks and regards ujang | oracle dba | mysql dba http://ora62.wordpress.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l