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

Check parameter log_checkpoint_interval - number of seconds between redo logs switching.

Haild wrote:

> 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.
>
> everyone tells us that ORA-01555: snapshot too old is only done when a change
> occurs to soruce tables if that ture can just a select being run.
>
> We have 10 rollback segements each 100M and total of 10 Gig in rollback
> tablespace area.
Received on Mon Dec 04 2000 - 06:25:09 CST