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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
