RE: Usage of COMMIT NOWAIT, BATCH

Hemant,

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

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale Sent: Saturday, February 02, 2008 3:17 AM To: oracle-l_at_freelists.org
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 Received on Mon Feb 04 2008 - 07:32:47 CST