log_buffer

  • From: "James Howerton" <jhowerton@xxxxxxxxx>
  • To: "oracle list" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 19 May 2008 17:04:38 -0500

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: