Usage of COMMIT NOWAIT, BATCH
From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 02 Feb 2008 16:17:14 +0800
Message-Id: <200802020817.m128HEmM020069@smtp43.singnet.com.sg>
Date: Sat, 02 Feb 2008 16:17:14 +0800
Message-Id: <200802020817.m128HEmM020069@smtp43.singnet.com.sg>
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 ; " ?
- How frequently ?
- What type of application / under what circumstances ?
- At SYSTEM or SESSION level ?
- For a limited duration during a Sesion or throughout a Session ?
Hemant K Chitale
http://hemantoracledba.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 02 2008 - 02:17:14 CST