-
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
-
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.
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|