Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Asynchronous Commit in Oracle Database 10g R2

Re: Asynchronous Commit in Oracle Database 10g R2

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 30 Aug 2005 13:03:45 +1000
Message-ID: <4313cc8f$0$30693$5a62ac22@per-qv1-newsreader-01.iinet.net.au>


yong321_at_yahoo.com apparently said,on my timestamp of 30/08/2005 7:29 AM:

> In 9i, 'log file
> sync' wait should increment by 1 or 2 depending on how the PL/SQL block
> is with the loop is written.

I dont'get this one. "depending" on what? There is no such thing as a status of pl/sql block.

> By the way, this has nothing to do with group commits
> (commit-piggyback).

did you confirm that with the source code? :)

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam
Received on Mon Aug 29 2005 - 22:03:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US