-
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
Imti
Junior DBA
-
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
Jim
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|