Re: SNAPSHOT TOO OLD (1555) - SOLUTION ?

djose_at_att.com wrote:

> Hello everyone,
>
> I have a Pro*C program which churns through 4 tables and
> creates a flat
> file. The program encounters oracle error code ORA-1555
> (SNAPSHOT TOO
> OLD ) causing it to exit.( I have an exit routine for non-zero
> return codes )
>
> The tables are as follows
>
> order
> order_details
> name
> address
>
> * The program basically creates a cursor on order table which pulls
> out all
> rows in that table.
> * For each order it pulls out data from the other 3
> tables.
> * I use a host array for the FETCHES with a batch size of 2000.
> * I
> also use the PARALLEL QUERY OPTION.
> * The program currently takes about 4-5
> hours to run.
> * The volumes in these tables are very high and transactions
> are continously
> updating the above tables.
>
>
> My Question :
> Is there any
> way I can work around the snapshot too old error ?
> Any help with respect to
> handling this error would
> be very much appreciated.
>
> Thanks for your time,
> Jude
>
> ( djose_at_att.com )

Two ways you get around this problem -
1. Have your DBA increase the size of rollback segments so that they will be written over more infrequently (and hence hold their 'snapshot' longer) 2. Run your query when the update activity on the database is low.

--
hope this helps !
Srini
(to reply, change "nospam" to "chavali" in my email address.  :-)  )