Re: ORA 1555 - Snapshot too old

In our last gripping episode "Carl Hathaway" <chathaw2_at_ford.com> wrote:
> 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
>
>

Dave Wotton has written a fairly concise and complete epistle on the vagaries of "Snapshot too old" errors. The link is:

http://home.clara.net/dwotton/dba/snapshot.htm

Please visit this site -- it should answer your questions.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/