Re: commit or not commit inside a cursor loop

Thanx Karsten for this precision, I missed it. I actually took the quote from Tom Kyte's site (asktom.oracle.com) from the year 2000. I don't have a metalink account presently.

Daniel

> One thing to notice, Daniel's quote is from Metalink Note 40689.1,
> created 03-Jan-1997, last revision 20-Sep-1999, and applies to Oracle7.
> However, that being said, it is still mostly correct in later versions,
> since the same basic info appears in Note 1005107.6, revised 10-May-2002
> (where a trade-off is mentioned in Case #3 for more frequent commits and
> a caveat at the end which says you tend to get the 1555s because Oracle
> "extended" the ANSI standard).
>
> So it all boils down to that old cliche: "It all depends."
Received on Fri May 30 2003 - 22:15:09 CDT