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