 | | | LOG FILE SYNC wait event | LOG FILE SYNC wait event 2007-09-04 - By LS Cheng
Back
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@(protected)> 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
>
<div>hi</div>
<div> </div>
<div>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<
/div>
<div> </div>
<div>thanks</div>
<div> </div>
<div>--</div>
<div>LSC</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 9/3/07, <b class="gmail_sendername">DBA
Deepak</b> <<a href="mailto:oracle.tutorials@(protected)">oracle.tutorials
@(protected)</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Hi All,</div>
<div> </div>
<div>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... </div>
<div> </div>
<div>> To move the redo logs to faster disks(Not feasible in our case).</div>
<div> </div>
<div>We are using AUTO SGA (10g R2) which can tune log buffer on its own(Please
correct me if I am wrong). <br clear="all"></div><span class="sg">
<div><br>-- <br>Regards,<br><br>Deepak<br>Oracle DBA </div></span></blockquote>
</div><br>
|
|
|