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.
As of now, I do not think you need to be alarmed.
I think, it is normal with Rollback Segments.
Hope this helps
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.
Click Here to Expand Forum to Full Width