LOG FILE SYNC wait event 2007-09-03 - By DBA Deepak
Back
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
<div>Hi All,</div>
<div> </div>
<div>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... </div>
<div> </div>
<div>> To move the redo logs to faster disks(Not feasible in our case).</div>
<div> </div>
<div>We are using AUTO SGA (10g R2) which can tune log buffer on its own(Please
correct me if I am wrong). <br clear="all"></div>
<div><br>-- <br>Regards,<br><br>Deepak<br>Oracle DBA </div>
|
|
