While executing a procedure, I am getting the 'snapshot too old...' error --

SQL> exec sms.computeloadterminaltm
begin sms.computeloadterminaltm; end;

*
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 7 with name "RBS4" too small
ORA-06512: at "SMS.COMPUTELOADTERMINALTM", line 24




I don't think though that increasing the rollback size will help because there is plenty of space in the tablespace for the rollback to grow but the high-water mark shows that it's not extending beyond initial 2 extents (mening it does not need more space for rollback)

The procedure involves a long group-by query that sends results into a table (insert into...)

Any idea why this "snapshot..." error when there is room for rollback to grow ?

Thanks,
- Rajeev