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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l