Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Snapshot too old, any way to disable consistency?

Snapshot too old, any way to disable consistency?

From: Greg Stark <gsstark_at_mit.edu>
Date: 10 Jul 1999 12:48:17 -0400
Message-ID: <87u2rcxxgu.fsf@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 Sat Jul 10 1999 - 11:48:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US