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_at_gmail.com> 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

>


--
http://www.freelists.org/webpage/oracle-l