Re: LOG FILE SYNC wait event

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
>

Other related posts: