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.
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.
ALTER ROLLBACK SEGMENT RBS01
STORAGE ( NEXT 1M OPTIMAL 5M);
Oracle Certified Professional "Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
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.