Re: Asynchronous Commit in Oracle Database 10g R2

On Sat, 27 Aug 2005 23:13:57 -0700, KDB wrote:

>
> Is it really true and oracle never told us about this ? Could you
> please share your 9i test case with me or point me to some URL?

It is my own experience. I created a table A(c1 number), executed the loop from post above and counted "io_submit" calls. Eventually, I counted the following:

grep io_submit /tmp/lgwr.out|wc -l
4408
And user commits (v$sesstat) was 5002. The obvious conclusion is that not every commit has caused write request to be generated. What that means is that Oracle optimizes 'COMMIT' statements in the loop like above and simply doesn't generate signals to LGWR. The whole thing was instigated by Jonathan, who had one day training session in Hartford, CT in March this year. My testing only supports Jonathan's statement.

-- 
http://www.mgogala.com