|
[oracle-l]
||
[Date Prev]
[09-2007 Date Index]
[Date Next]
||
[Thread Prev]
[09-2007 Thread Index]
[Thread Next]
Re: LOG FILE SYNC wait event
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: oracle.tutorials@xxxxxxxxx
- Date: Tue, 4 Sep 2007 07:54:10 +0200
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
>
|
|
