Re: ORA 1555 - Snapshot too old

From: Spencer <spencerp_at_swbell.net>
Date: Tue, 9 Jan 2001 20:58:00 -0600
Message-ID: <nbQ66.748$6W3.208558@nnrp2.sbc.net>

In short, yes, a select query may need to access blocks in rollback segments. For more details, see http://www.ixora.com.au/tips/admin/ora-1555.htm

HTH "Carl Hathaway" <chathaw2_at_ford.com> wrote in message news:92sq6u$shu7_at_eccws12.dearborn.ford.com...
> Can someone explain why the solution given to resolving the above error
(ora
> 1555 snapshot too old rollback segment to small) is to increase the
rollback
> segment size. in particular where long running queries are being
processed.
> Does a select query access the rollback segments?
>
> Carl
>
>
>
Received on Tue Jan 09 2001 - 20:58:00 CST