Re: log_buffer
From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Tue, 20 May 2008 09:21:20 +0700
Message-ID: <3edcb66e0805191921r183d8d1cr4bf130f1bfd578d3@mail.gmail.com>
Date: Tue, 20 May 2008 09:21:20 +0700
Message-ID: <3edcb66e0805191921r183d8d1cr4bf130f1bfd578d3@mail.gmail.com>
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_at_uabmc.edu> wrote:Received on Mon May 19 2008 - 21:21:20 CDT
> 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...
-- http://www.freelists.org/webpage/oracle-l