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?
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.
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.
Bookmarks