Re: Usage of COMMIT NOWAIT, BATCH
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Sat, 2 Feb 2008 10:21:44 +0100
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@xxxxxxxxxxxxxx> 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
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
