|
-
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!
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
|
Reply With Quote