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: 30 Aug 2005 19:45:12 -0700
Message-ID: <1125456312.637905.86520@g43g2000cwa.googlegroups.com>


yong321_at_yahoo.com wrote:
> I don't get it either!, because I'm not sure about the exact condition.
> But it looks like using an implicit vs. explicit cursor influences the
> number of log file sync waits. My test case is at
> http://rootshell.be/~yong321/oranotes/CursorImplicitExplicitCommit.txt

Thanks, will run it on my systems as well to see what gives. The thing that worries me a bit is we may be classing this as an undocumented optimization when it might well be something else! The lack of any pattern to how it increments seems to point to an "undocumented feature" anyway. Not that it hasn't ever happened... Received on Tue Aug 30 2005 - 21:45:12 CDT

Original text of this message

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