Re: Snapshot too old

From: Paul de Anguera and family <paul.deanguer_at_quidnunc.net>
Date: 1998/08/28
Message-ID: <35E789B3.292F_at_quidnunc.net>#1/1


David Ng wrote:
...
> I got a problem with a data loading program. The program always terminated
> with Oracle error
> of "Snapshot too old" even the program commit evey 50 record. ...
Try increasing the OPTIMAL parameter for the rollback segment, so its extents are kept longer. For heavy duty batch runs we created a special rollback segment in its own tablespace and set OPTIMAL so its extents are never released. Use SET TRANSACTION or put the other rollback segments offline to force use of the big one. You might have to make the tablespace larger too, until you discover how much you have to retain to make your program work.

I think "Snapshot too old" happens to readers of data, not writers. Maybe your load program does some SELECTs for editing too, or maybe constraints cause implicit SELECTs? If you're sure your data is clean, another thought is to drop the indexes on the table being loaded and create them again when you're through. Good luck!

-- 
Welcome to our web page -- it's at
http://www.quidnunc.net/~deanguer/index.htm
Received on Fri Aug 28 1998 - 00:00:00 CEST

Original text of this message