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

Home -> Community -> Usenet -> c.d.o.server -> ORA 1555 - Snapshot too old

ORA 1555 - Snapshot too old

From: Carl Hathaway <chathaw2_at_ford.com>
Date: Tue, 2 Jan 2001 14:57:07 -0000
Message-ID: <92sq6u$shu7@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 02 2001 - 08:57:07 CST












Original text of this message













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