Re: Snapshot too old, but I don't care about read consistency for this query

From: David Sisk <davesisk_at_ipass.net>
Date: Tue, 13 Jul 1999 22:15:26 -0400
Message-ID: <ugSi3.152$w3.290@news.ipass.net>

There is no way to disable consistent reads. Try making your rollback segments bigger (usually meaning increase max_extents setting).

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Greg Stark wrote in message <87hfn86zcf.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 Tue Jul 13 1999 - 21:15:26 CDT