RE: log file sync
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <oracle@xxxxxxxxxxxx>
- Date: Tue, 10 Oct 2006 22:37:06 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
