Usage of COMMIT NOWAIT, BATCH

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 02 Feb 2008 16:17:14 +0800
Message-Id: <200802020817.m128HEmM020069@smtp43.singnet.com.sg>

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
Received on Sat Feb 02 2008 - 02:17:14 CST

Original text of this message