Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 03 2007 - 10:48:05 CDT