Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Waits on log file sync
As part of Benchmarking Runs , there Exist WAITS on log file sync
log_buffer_size = 4 MB
log_checkpoint_interval value Greater than Redo file Size to Cause
Checkpointing
only on log Switch
log switch happening every 10 minutes
Transactions primarily OLTP in nature
NOTE - Previously though there were NO such waits
Online Redo logs Exist on RAID 0+1
Can NOT Change Commit Frequency either
SVRMGR> Rem System wide wait events for non-background processes (PMON, SVRMGR> Rem SMON, etc). Times are in hundreths of seconds. Each one of SVRMGR> Rem these is a context switch which costs CPU time. By looking at SVRMGR> Rem the Total Time you can often determine what is the bottleneck SVRMGR> Rem that processes are waiting for. This shows the total time spent SVRMGR> Rem waiting for a specific event and the average time per wait on SVRMGR> Rem that event. SVRMGR> select n1.event "Event Name", 2> n1.event_count "Count", 3> n1.time_waited "Total Time", 4> round(n1.time_waited/n1.event_count, 2) "Avg Time" 5> from stats$event n1 6> where n1.event_count > 0 7> order by n1.time_waited desc; Event Name Count Total Time Avg Time -------------------------------- ------------- ------------- ------------- SQL*Net message from client 17736895 174027138 9.81 log file sync 493066 16768066 34.01 latch free 10635868 8429387 .79 row cache lock 20006 4551336 227.5 enqueue 464758 4371312 9.41 buffer busy waits 73994 2303119 31.13 library cache pin 26423 866739 32.8Received on Fri Sep 08 2000 - 07:35:43 CDT
![]() |
![]() |