RE: Building Slow Development Systems (On Purpose)

From: Yong Huang <>
Date: Thu, 28 May 2009 09:34:32 -0700 (PDT)
Message-ID: <>

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 (my session is 92).

-- Received on Thu May 28 2009 - 11:34:32 CDT

Original text of this message