I agree- there are cases where you have very large SGA's, and due to the granule size oracle will ignore a setting for redo log buffer and increase it. For instance, 200gb sga on Linux will cause a 128mb redo log buffer, because the granule size will be set to 512mb. In order to reduce redo log buffer you have to force the granule size to be smaller using an undocumented parameter. From: Ls Cheng [mailto:exriscer@xxxxxxxxx] Sent: Tuesday, May 29, 2012 12:13 PM To: rodrigo@xxxxxxxxxxxxxxx Cc: CRISLER, JON A; oracle-l@xxxxxxxxxxxxx Subject: Re: log buffer size and log file syncs the docu is rubbish in this case, because if you let oracle itself configure log_buffer it sets like 15MB (a lot more than 1MB it suggests huh) -- //www.freelists.org/webpage/oracle-l