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-l