Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: log file sync
Hi
> I am trying to uncover the root cause of log file sync waits causing
> an application to decrease in performance. 10046 trace shows
> hundreds of thousands of lines of log file sync with ela time around
> 1000. 1ms by itself isn't so bad but throughout the duration of the
> process it becomes a serious problem.
In addition to the good advices you already got...
For every commit there is a line in the tracefile. You can use a command like the following one to count them:
grep "XCTEND rlbk=0" <tracefile> | wc -l
HTH
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 10 2006 - 15:37:06 CDT
![]() |
![]() |