RE: Building Slow Development Systems (On Purpose)
Date: Thu, 28 May 2009 09:34:32 -0700 (PDT)
The commit options actually exist in 10gR2 and up, not 10gR1. Also explicitly setting commit_write = 'immediate,wait' (e.g. with alter session) has the same effect.
- Yong Huang wrote -----
If you need each log file sync for each commit inside PL/SQL, you can try
commit write immediate wait if you're on 10g and up. The test below is on
10.2.0.1 (my session is 92).
http://www.freelists.org/webpage/oracle-l Received on Thu May 28 2009 - 11:34:32 CDT