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=CJ7+WInlWrKc1pSocGJVprmuQ9Uj7E2JIvl7LB4XbYoigFgCVRWuxFFjpSSeFV/ow+Ctm9hfp6SfWmTwTrAlDGtRFLuC/IlmudgKo4+0RtKhTb+dkVejZCnE3uKKd75KK9hHoj+9EpuiQWPZuqTNhcJWEdOzDzvNP7hPtr8pRYM=
Message-ID: <6e9345580802020121y401aa5ebifecde9f3537896a3@mail.gmail.com>
Date: Sat, 2 Feb 2008 10:21:44 +0100
From: "LS Cheng" <exriscer@gmail.com>
To: hkchital@singnet.com.sg
Subject: Re: Usage of COMMIT NOWAIT, BATCH
Cc: oracle-l@freelists.org
In-Reply-To: <200802020817.m128HEmM020069@smtp43.singnet.com.sg>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_11387_13490597.1201944104335"
References: <200802020817.m128HEmM020069@smtp43.singnet.com.sg>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: exriscer@gmail.com
------=_Part_11387_13490597.1201944104335
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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


On 2/2/08, Hemant K Chitale <hkchital@singnet.com.sg> wrote:
>
>
> I just want to conduct a poll :
> How frequent and in what circumstances do you use or see used
> the "ALTER SYSTEM|SESSION  COMMIT_WRITE = nowait, batch ; " ?
>
> 1.  How frequently ?
> 2.  What type of application / under what circumstances ?
> 3.  At SYSTEM or SESSION level ?
> 4.  For a limited duration during a Sesion or throughout a Session ?
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

<div>Hi</div>
<div>&nbsp;</div>
<div>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?</div>
<div>&nbsp;</div>
<div>So far I have not seen this used in production</div>
<div>&nbsp;</div>
<div>Thanks</div>
<div>&nbsp;</div>
<div>--</div>
<div>LSC</div>
<div><br><br>&nbsp;</div>
<div><span class="gmail_quote">On 2/2/08, <b class="gmail_sendername">Hemant K Chitale</b> &lt;<a href="mailto:hkchital@singnet.com.sg">hkchital@singnet.com.sg</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br>I just want to conduct a poll :<br>How frequent and in what circumstances do you use or see used<br>the &quot;ALTER SYSTEM|SESSION&nbsp;&nbsp;COMMIT_WRITE = nowait, batch ; &quot; ?<br>
<br>1.&nbsp;&nbsp;How frequently ?<br>2.&nbsp;&nbsp;What type of application / under what circumstances ?<br>3.&nbsp;&nbsp;At SYSTEM or SESSION level ?<br>4.&nbsp;&nbsp;For a limited duration during a Sesion or throughout a Session ?<br><br><br>Hemant K Chitale<br>
<a href="http://hemantoracledba.blogspot.com">http://hemantoracledba.blogspot.com</a><br><br><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_11387_13490597.1201944104335--
--
http://www.freelists.org/webpage/oracle-l