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

Thread: rollback segs

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Post

    I checked the rollback segments using storage manager and I got something like this:

    NAME SIZE HIGH WATER MARK (M)
    R01 1.018 1.010
    R02 1.018 1.010
    R03 1.018 1.010
    R04 1.018 1.010
    R05 1.018 1.010
    R06 1.018 1.000
    The system rollback segmnet is okay.

    Does this mean I have to resize the storage parameters for the rollback segs since they are getting closer to the high water mark?
    Any other advice for a rookie me like regarding rollback segs will be highly appreciated.

    still learning,
    learn

    [Edited by learn on 12-17-2000 at 10:59 AM]

  2. #2
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    No worries

    Rollback segments reuse storage as long as your transactions are commiting. You may want to check and see if they have the shrink parameter set so that they will shrink and free up space when they are not in use

    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  3. #3
    Join Date
    Nov 2000
    Posts
    169
    How do I find out if the roll back segments have shrink parameter set?

  4. #4
    Join Date
    Nov 2000
    Posts
    71
    You must seee if the OPTIMAL SIZE is set to a non 0 value.
    If you decide to set it remember that it CAN NOT be minor than the size allocated by the MINEXTENTS paramenter form that rollback segment.
    Bye

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hi
    if you want to tune your rollback segment you have to check wraps & shrinks in v$rollstat.
    keep wraps as near to zero as possible
    keep shrinks as few as possible

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