RE: log buffer size and log file syncs

From: CRISLER, JON A <JC1706_at_att.com>
Date: Tue, 29 May 2012 16:33:45 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD32A64AB_at_MISOUT7MSGUSR9D.ITServices.sbc.com>



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_at_gmail.com] Sent: Tuesday, May 29, 2012 12:13 PM
To: rodrigo_at_mufalani.com.br
Cc: CRISLER, JON A; oracle-l_at_freelists.org 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
Received on Tue May 29 2012 - 11:33:45 CDT

Original text of this message