Re: Usage of COMMIT NOWAIT, BATCH

From: LS Cheng <exriscer_at_gmail.com>
Date: Sat, 2 Feb 2008 10:21:44 +0100
Message-ID: <6e9345580802020121y401aa5ebifecde9f3537896a3@mail.gmail.com>


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_at_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
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 02 2008 - 03:21:44 CST

Original text of this message