Re: rollback/commit question

Thanks all, I just did a commit at the end, and it now works. I have corrected my email address as well. I hope I don't get spammed to death now.

On Wed, 02 Feb 2000 22:49:59 GMT, "Dave Wotton" <Dave.Wotton_at_dwotton.nospam.clara.co.uk> wrote:

>
>Jay Scheiner wrote in message <3898b7b5.1353365401_at_news.erols.com>...
>....
>>Please comment on other reply to my post, if you could- that I am
>>committing too frequently. I have not yet looked at the author's web
>>site.
>
>
>Yes, you are committing too frequently. Committing without closing
>and re-opening your read cursor will make you prone to snapshot too
>old, as you've discovered. The best solution is to close and reopen
>the cursor immediately after your commit statement. This will prevent
>snapshot too old, and the commits prevent your rollback segment growing
>too big. However, closing and opening the cursor is very expensive, so
>you should try to minimise the number of times you do it by decreasing
>the number of commits - I'd suggest every 2000-3000 rows. (But this must
>be balanced by the maximum size you want your rollback segments to grow:
>the fewer the commits, the bigger the rollback segments you will need.)
>For more details, as an alternative to the Ixora website, see my web-page:
>
> http://home.clara.net/dwotton/dba/snapshot.htm
>
>BTW, your email address doesn't appear to work.
>
>Dave.
>--
>There's no need to reply to this posting by email, but if you do,
>remove the "nospam" from my email address first.I provide a
>
>
Received on Mon Feb 07 2000 - 14:21:34 CST