Can I Resize Rollback Segment Size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Can I Resize Rollback Segment Size

  1. #1
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31

    Arrow

    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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    Jan 2002
    Posts
    48
    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.

  4. #4
    Join Date
    Feb 2002
    Posts
    267


    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
  •  



Click Here to Expand Forum to Full Width