RE: Building Slow Development Systems (On Purpose)
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 28 May 2009 09:34:32 -0700 (PDT)
Message-ID: <930128.39700.qm_at_web80601.mail.mud.yahoo.com>
Date: Thu, 28 May 2009 09:34:32 -0700 (PDT)
Message-ID: <930128.39700.qm_at_web80601.mail.mud.yahoo.com>
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
Received on Thu May 28 2009 - 11:34:32 CDT