Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
v$rollstat.staus is FULL
- Thread starter Matsul
- Start date
A status of full means that the rollback segment has reached its maximum number of extents. It remains online, but the full status prevents any new transactions from getting assigned to this rollback segment.
Taking the rollback segment offline and then putting it back online should clear the full status. That would cause all active transactions in the rollback segment to be rolled back.
On the other hand, I don't think just altering the rollback segment online would have any effect, since it's online to begin with. I suppose I could be wrong, but I suspect that one or more transactions just happened to complete while you were doing the alter. That would also clear the full status, since the completed transactions would no longer need their rollback segment allocations.
Taking the rollback segment offline and then putting it back online should clear the full status. That would cause all active transactions in the rollback segment to be rolled back.
On the other hand, I don't think just altering the rollback segment online would have any effect, since it's online to begin with. I suppose I could be wrong, but I suspect that one or more transactions just happened to complete while you were doing the alter. That would also clear the full status, since the completed transactions would no longer need their rollback segment allocations.
- Status
Similar threads
- Locked
- Question