RE: Building Slow Development Systems (On Purpose)

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

----- 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

Other related posts: