Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback/commit question
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 Wed Feb 02 2000 - 16:49:59 CST