RE: log buffer size and log file syncs

From: "CRISLER, JON A" <JC1706@xxxxxxx>
To: Ls Cheng <exriscer@xxxxxxxxx>, "rodrigo@xxxxxxxxxxxxxxx" <rodrigo@xxxxxxxxxxxxxxx>
Date: Tue, 29 May 2012 16:33:45 +0000

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)

--
http://www.freelists.org/webpage/oracle-l

References:

Re: log buffer size and log file syncs
From: Ls Cheng

RE: log buffer size and log file syncs

Other related posts: