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"
Click HERE to vist my website!
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
Click Here to Expand Forum to Full Width