RE: LOG FILE SYNC wait event
- From: Adrian <ade.turner@xxxxxxxxx>
- To: <oracle.tutorials@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 Sep 2007 19:07:53 +0100
Unfortunately you dont provide full information as to the profile of the log
file sync wait event. Does "Lot of" mean large numbers of events of short
duration or a large amount of wait time attributable to log file sync.
For better understanding of the way forward please consider providing
* Select * from v$event_histogram where event in ('log file parallel
write', 'log file sync');
* AWR output to determine the average wait time and if timeouts are
occurring.
* Information on whether the server is CPU bound as this will
exacerbate log file sync times.
* Platform and file system information, including database and
filesystem block size.
Cheers
Adrian
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of DBA Deepak
Sent: 03 September 2007 16:48
To: oracle-l
Subject: LOG FILE SYNC wait event
Hi All,
We are having a lot of Log file sync waits because of frequent commits
issued from the third party application. What are the solutions to fix this
apart from the follwing one...
> To move the redo logs to faster disks(Not feasible in our case).
We are using AUTO SGA (10g R2) which can tune log buffer on its own(Please
correct me if I am wrong).
--
Regards,
Deepak
Oracle DBA
Other related posts:
