Re: Snapshot too old, any way to disable consistency?

Check to see if optimal is set on your rollback segments. If it is, you may want to try increasing (or removing it).

Steve Dancisin / sdancisin_removethis_at_highmark.com

Greg Stark wrote in message <87u2rcxxgu.fsf_at_mit.edu>...
>
>I have a long-running "select *" query--it takes hours to process all the
>records--and sometimes I get "snapshot too old" for some of the rows. Is
there
>any way to convince Oracle that I really don't care about consistent reads
>here, just fetch the most recent data from that record? This is especially
>important because I'm considering enabling discrete transactions for the
>updates anyways, so these errors will become much more frequent.
>
>greg
>
Received on Mon Jul 12 1999 - 08:33:29 CDT