6.295 DBA_QUARANTINED_TRANSACTIONS
DBA_QUARANTINED_TRANSACTIONS
lists all quarantined transactions in the current container.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Undo segment number of the quarantined transaction |
|
|
|
Slot number of the quarantined transaction |
|
|
|
Sequence number of the quarantined transaction |
|
|
|
Reason the transaction failed to recover |
|
|
|
Name of the trace file containing the reason for the transaction's recovery failure, along with diagnostic information about the failure |
|
|
|
Undo tablespace number for the quarantined transaction |
|
|
|
Dictionary object number of the object (OBJN) |
|
|
|
Dictionary object number of the segment that contains the object (OBJD) |
|
|
|
Tablespace ID for the object |
|
|
|
Previous undo block address, which was used for rollback |
|
|
|
Relative data block address of the current undo block being applied for rollback |
|
|
|
Undo block sequence number of the current undo block being applied for rollback |
|
|
|
Undo record number of the current undo block being applied for rollback |
|
|
|
Start SCN of the quarantined transaction |
|
|
|
Time at which the incident occurred |
Note:
This view is available starting with Oracle Database 23ai.
See Also: