DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=sYDByr9csZDP2lI7zt2ZT2qThVLb0S2LI1cfp7BTQjKo2UvsDZPdmvLqIhOjFCvvynzCZq5N0Qd33t0pTbzrK/488+DBpMnN+uwG06H+r/ihZfZCPULcaPJRt4M+wLu8OaM7g9Xkm8eCTLeytvSwImQQecDtp81Ff+Aw2amCrM8=
Message-ID: <6e9345580802020252s4f0a05eu2df357afb552d3aa@mail.gmail.com>
Date: Sat, 2 Feb 2008 11:52:31 +0100
From: "LS Cheng" <exriscer@gmail.com>
To: jonathan@jlcomp.demon.co.uk
Subject: Re: Usage of COMMIT NOWAIT, BATCH
Cc: oracle-l@freelists.org
In-Reply-To: <012601c86584$337c9430$0200a8c0@Primary>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_11447_12118249.1201949551166"
References: <200802020817.m128HEmM020069@smtp43.singnet.com.sg>
	 <6e9345580802020121y401aa5ebifecde9f3537896a3@mail.gmail.com>
	 <012601c86584$337c9430$0200a8c0@Primary>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: exriscer@gmail.com
------=_Part_11447_12118249.1201949551166
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Jonathan

I forgot to mention that this is a insert intensive application so 3 seconds
would not apply I guess. The insert rate is around 1000 to 2000 per seconds.

I guess the upper bound would be

1/3 log buffer
3 seconds
when the log buffer is full

no?

Thanks

--
LSC


On 2/2/08, Jonathan Lewis <jonathan@jlcomp.demon.co.uk> wrote:
>
>
> As much data as had not been protected by the log writer since
> it last write - i.e. as much as three seconds of log.
>
> Of course, if you had a long running transaction that took
> three hours to complete, and the COMMIT for that transaction
> was in that three seconds, then the three hours would be rolled
> back on recovery.
>
>
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> From: "LS Cheng" <exriscer@gmail.com>
> To: <hkchital@singnet.com.sg>
> Cc: <oracle-l@freelists.org>
> Sent: Saturday, February 02, 2008 9:21 AM
> Subject: Re: Usage of COMMIT NOWAIT, BATCH
>
>
> > Hi
> >
> > It just occured to me yesterday to use this in a customer but does
> anyone
> > know how much data would we lose if there is an instance failure?
> >
> > So far I have not seen this used in production
> >
> > Thanks
> >
> > --
> > LSC
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

------=_Part_11447_12118249.1201949551166
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi Jonathan</div>
<div>&nbsp;</div>
<div>I forgot to mention that this is a insert intensive application so 3 seconds would not apply I guess. The insert rate is around 1000 to 2000 per seconds.</div>
<div>&nbsp;</div>
<div>I guess the upper bound would be</div>
<div>&nbsp;</div>
<div>1/3 log buffer</div>
<div>3 seconds</div>
<div>when the log buffer is full</div>
<div>&nbsp;</div>
<div>no?</div>
<div>&nbsp;</div>
<div>Thanks</div>
<div>&nbsp;</div>
<div>--</div>
<div>LSC</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><br><br>&nbsp;</div>
<div><span class="gmail_quote">On 2/2/08, <b class="gmail_sendername">Jonathan Lewis</b> &lt;<a href="mailto:jonathan@jlcomp.demon.co.uk">jonathan@jlcomp.demon.co.uk</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br>As much data as had not been protected by the log writer since<br>it last write - i.e. as much as three seconds of log.<br>
<br>Of course, if you had a long running transaction that took<br>three hours to complete, and the COMMIT for that transaction<br>was in that three seconds, then the three hours would be rolled<br>back on recovery.<br><br>
<br>Regards<br><br>Jonathan Lewis<br><a href="http://jonathanlewis.wordpress.com">http://jonathanlewis.wordpress.com</a><br><br>Author: Cost Based Oracle: Fundamentals<br><a href="http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html">http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html</a><br>
<br>The Co-operative Oracle Users&#39; FAQ<br><a href="http://www.jlcomp.demon.co.uk/faq/ind_faq.html">http://www.jlcomp.demon.co.uk/faq/ind_faq.html</a><br><br><br>----- Original Message -----<br>From: &quot;LS Cheng&quot; &lt;<a href="mailto:exriscer@gmail.com">exriscer@gmail.com</a>&gt;<br>
To: &lt;<a href="mailto:hkchital@singnet.com.sg">hkchital@singnet.com.sg</a>&gt;<br>Cc: &lt;<a href="mailto:oracle-l@freelists.org">oracle-l@freelists.org</a>&gt;<br>Sent: Saturday, February 02, 2008 9:21 AM<br>Subject: Re: Usage of COMMIT NOWAIT, BATCH<br>
<br><br>&gt; Hi<br>&gt;<br>&gt; It just occured to me yesterday to use this in a customer but does anyone<br>&gt; know how much data would we lose if there is an instance failure?<br>&gt;<br>&gt; So far I have not seen this used in production<br>
&gt;<br>&gt; Thanks<br>&gt;<br>&gt; --<br>&gt; LSC<br>&gt;<br><br>--<br><a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a><br><br><br></blockquote></div><br>

------=_Part_11447_12118249.1201949551166--
--
http://www.freelists.org/webpage/oracle-l