Can I Resize Rollback Segment Size

Dear friend,

My database oracle 8.1.7is running on Sun but some time I am getting message roll back segment too small.I want to resize the rollback segment .So pls suggest me to how to increase size of rollback segment.If I will create new rollback segment then what are the parameters are for sizing the rollback segment.
Thanks
Imti

The size of a rollback segment depends entirely on database activity. But you can either drop and recreate a rollback segment or you can modify it's storage parameters to create larger extent sizes or increase the maximum number of extents.

eg

ALTER ROLLBACK SEGMENT RBS01
STORAGE ( NEXT 1M OPTIMAL 5M);

Regards

Increase your rbs tablespace datafiles and then adjust maxextents on both tablespace and all rollback segments in it. Keep other rbs storage parameters as they are. Create new rbs if you see waits for rbs.

set a higher value for initial
increase the no of minextents
set an high value of optimal parameter