RE: Usage of COMMIT NOWAIT, BATCH

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <hkchital@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 4 Feb 2008 08:32:47 -0500

Hemant,

Never seen it, used it and obviously seen the need for it.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hemant K Chitale
Sent: Saturday, February 02, 2008 3:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Usage of COMMIT NOWAIT, BATCH


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


Other related posts: