Q
Problem solve Get help with specific problems with your technologies, process and projects.

Help with ORA-01555: snapshot too old

I have a table with 70,000 rows and one of the columns is CLOB data type. When I try to select * from that table I get the following error:

ERROR: ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old

The database is Oracle9i release 1 and I am using undo tablespace.
You get the ORA-1555 message when you try to access data that someone else is modifying, and Oracle has lost the information that it needs to construct a read-consistent image of that data to present to you. Since you are using Oracle9i's new UNDO tablespace, the ORA-1555 error is an indication that your UNDO_RETENTION parameter is not large enough. You can monitor this by querying the SSOLDERRCNT (Snap Shot Too Old Error Count) column of V$UNDOSTAT. Increase the UNDO_RETENTION parameter and these errors will go away.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close