DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: need help with rollback segs

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Question

    I checked my rollback segs using OEM and the space allocated is 1M and the highwater mark is 1.4m. Should I be alarmed? Is that a problem? What should I do?

    still learning,
    learn

  2. #2
    Join Date
    Sep 2000
    Posts
    155

    High Water Mark represents the maximum point that this rollback segment has reached at some point. If a transaction of too large, the rollback segment can extend as long as it can until it reaches the MAXEXTENTS value.

    As of now, I do not think you need to be alarmed.

    I think, it is normal with Rollback Segments.

    Hope this helps

  3. #3
    Join Date
    Mar 2000
    Location
    Sydney
    Posts
    9
    There is no harm as such with this. You can get rid of this rollback segment if you do not need this anymore. Just make sure using v$transaction that the rollback segment is not in use before that.

    Hope this helps.
    GK

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