log_buffer
From: James Howerton <jhowerton_at_uabmc.edu>
Date: Mon, 19 May 2008 17:04:38 -0500
Message-Id: <4831B324.DC6D.004D.0@uabmc.edu>
Date: Mon, 19 May 2008 17:04:38 -0500
Message-Id: <4831B324.DC6D.004D.0@uabmc.edu>
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
Received on Mon May 19 2008 - 17:04:38 CDT