Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01555: snapshot too old: rollback segment number 9 with name "_SYSSMU9$

ReneetApr 24 2007 — edited Apr 27 2007

Hi People,

I have recently been requested to help maintain an oracle enterprise database running on Oracle 9.2.0.1.0. A specific application seems to be problematic. There is a table in the application that has over 15 million records. The table is constantly updated throughout the day. Today while some people were trying to perform a query on the table they kept on getting the error
ORA-01555: snapshot too old: rollback segment number 9 with name "_SYSSMU9$ too small.

I have increased the undo_retention from the original 10800 to 16200
I have added another datafile to the UNDO tablespace with size 5711752 kb.
I have increased the rollback_segment from 800 to 1600

All these have not sought out the problem.

I know I have to read more on this but at the moment we need to run the query desperately and I need quick solutions.

Any help.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2007

Added on Apr 24 2007

#general-database-discussions

27 comments

18,425 views