Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Asynchronous Commit in Oracle Database 10g R2
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
![]() |
![]() |