Re: Is it possible to get a ORA-01555: snapshot too old even if no tables were updated during select

haild_0234_at_hotmail.com (Haild) writes:

> we have a longrunning sql stemeten that select all rows from a large join that
> meet a conditon, it runs for several hours due to amount of data being
> processed.
>
> we are getting ORA-01555: snapshot too old eventhougth none of the source
> tables were changed in any way no updates or inserts or deletes. in fact the
> last timestamp on any of the talbes was over 13 hours earlier
>
> our logs show that the select was the only statement running at the time.

was any DDL done?

Conceivably the updates had done a "fast commit" and weren't written to until your select? In that case try doing a select count(*) from each table before doing your massive join? I'm grasping at straws here.

As far as I know this could only happen if there was a update insert or delete against one of the tables. You could try setting the tablespace read-only which maybe would prevent oracle from even trying to check if there were any updates? I dunno, it sounds awfully weird.

-- 
greg