rollback segs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: rollback segs

  1. #1
    Join Date
    Feb 2001
    Posts
    83

    Question rollback segs

    Hello Guys,

    From the following reading of v$rollstat, wat are the things to be noticed ??

    extents 20
    rssize 10641408
    WAITS 195
    OPTSIZE 10485760
    HWMSIZE 10641408
    SHRINKS 0
    WRAPS 912

    Thanks for ur suggestions


    [Edited by prasy on 10-15-2001 at 02:16 PM]
    with regards
    Prasanna S

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    High Waits/wraps indicate that you have fewer rbs.

  3. #3
    Join Date
    Feb 2001
    Posts
    389
    Since waits and wraps are more, u may need to increase the number of rollback segments, also check v$waitstat to confirm this.

  4. #4
    Join Date
    Feb 2001
    Posts
    83
    Thanks for the replies.

    Is there anything to do with the size ??

    with regards
    Prasanna S

  5. #5
    Join Date
    Feb 2001
    Posts
    389
    u need to divulge , avg active size , extsnd and avg shrink.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Prasy
    Thanks for the replies.

    Is there anything to do with the size ??

    Size is probably OK, you might go however to 1M extents on the RBSs depending on your transactions. But you need more RBSs. You should carefully estimate their number.

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