Re: Asynchronous Commit in Oracle Database 10g R2

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 03 Sep 2005 02:33:16 GMT
Message-Id: <pan.2005.09.03.02.33.15.514464@sbcglobal.net>

On Fri, 02 Sep 2005 20:37:04 -0400, VC wrote:

> If you mean committing inside a PL/SQL proc, then arguably one should not
> be doing so at all. I do not understand your using the word
> 'asynchronously' in the last sentence, though.

By "asynchronously", he means that the procedure doesn't wait for the commit to complete. The commit will take effect at later stage, when the buffer is written. That is why I saw different number of io_submit calls. If you use a DB-link, you will wait for commit, which means that the commit will be done synchronously. I am afraid that this optimization is no longer unknown/undocumented after this discussion.

-- 
http://www.mgogala.com

Received on Fri Sep 02 2005 - 21:33:16 CDT