hi if you dont care lose data when instance crashes you can try commit batch nowait, I have a customer who set that becase they could afford lose some data thanks -- LSC On 9/3/07, DBA Deepak <oracle.tutorials@xxxxxxxxx> wrote: > > 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 >