Discussion Board

Rollback Segment Rollback segment status can be viewed through DBA_ROLLBACK_SEGS. The rollback segments can be either private or public. A rollback segment in the PARTLY AVAILABLE state contains data for an in-doubt or recovered distributed transaction, and yet to be recovered transactions. You can view its status in the data dictionary view DBA_ROLLBACK_SEGS as PARTLY AVAILABLE. The rollback segment usually remains in this state until the transaction is resolved either automatically by RECO, or manually by a DBA. However, you might find that all rollback segments are PARTLY AVAILABLE. Prajakta Pandit 02-28-2017 04:39 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*