*** URGENT *** ora-01555 rollback segment too small
Posted on 2001-06-19
.VB client, Weblogic5.1 app server, and Oracle 8.1.6 back end.
.Whenever I get a user base of circa 50 users I get the error :- java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number string with name "string" too small.
Solutions already tried:
.Increassed size of rollback segment
.Made rollback segment space unlimited
.Deleted and replace rollback segments
.Monitored the rollback segment useage when error is produced and useage is only at about 35%
Has anyone any idea what else could be causing this, ITS DRIVING ME ROUND THE BEND :)