Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Strange snapshot too old during a select statement
Hi list!
we encounter a very strange "ORA-01555 : snapshot too old :rollback segment
number 3 with name "_SYSSMU3$" too small"
This is a very long query
With a query that only make a select statement.
We have open a TAR with Oracle Support but they say that it's not possible
since this only a "select" statement ?!!
Any idea ?
TIA
Philippe
![]() |
![]() |