Usage of COMMIT NOWAIT, BATCH

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 02 Feb 2008 16:17:14 +0800


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: