Re: log_buffer
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: jhowerton@xxxxxxxxx
- Date: Tue, 20 May 2008 09:21:20 +0700
jim,
I never set log_buffer > 10mb
on high oltp system, I set it to 3mb.
mostly log file sync is due to frequent commit and "may be" slow io.
--
thanks and regards
ujang | oracle dba
jakarta - indonesia
On Tue, May 20, 2008 at 5:04 AM, James Howerton <jhowerton@xxxxxxxxx> wrote:
> DBA's,
>
> What is you're log_buffer set to??? I have a 2 Tb oltp two node RAC database
> on 10.1.0.5 that is showing lots of log file sync waits. My current setting
> is 1.5 Mb. Redo log files are 2Gb each.
>
>
> Top 5 Timed Events
> ~~~~~~~~~~~~~~~~~~ % Total
> Event Waits Time (s) DB Time Wait
> Class
> ------------------------------ ------------ ----------- ---------
> --------------
> log file sync 356,123 113,472 64.41
> Commit
> log buffer space 35,114 26,771 15.20
> Configuration
> buffer busy waits 21,139 13,489 7.66
> Concurrency
> CPU time 7,996 4.54
> gcs drm freeze in enter server 564,623 5,753 3.27
> Other
>
> TIA
> ...JIM...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
