DBA_QUARANTINED_TRANSACTIONS

DBA_QUARANTINED_TRANSACTIONS lists all quarantined transactions in the current container.

Column	Datatype	NULL	Description
USN	NUMBER	NOT NULL	Undo segment number of the quarantined transaction
SLT	NUMBER	NOT NULL	Slot number of the quarantined transaction
SQN	NUMBER	NOT NULL	Sequence number of the quarantined transaction
REASON	VARCHAR2(256)		Reason the transaction failed to recover
TRACE_FILE_NAME	VARCHAR2(4096)		Name of the trace file containing the reason for the transaction’s recovery failure, along with diagnostic information about the failure
UNDO_TSN	NUMBER		Undo tablespace number for the quarantined transaction
UNDO_RECORD_OBJN	NUMBER		Dictionary object number of the object (OBJN)
UNDO_RECORD_OBJD	NUMBER		Dictionary object number of the segment that contains the object (OBJD)
DATA_BLOCK_TSN	NUMBER		Tablespace ID for the object
PREV_UNDO_BLOCK_DBA	NUMBER		Previous undo block address, which was used for rollback
UBA_RDBA	NUMBER		Relative data block address of the current undo block being applied for rollback
UBA_SQN	NUMBER		Undo block sequence number of the current undo block being applied for rollback
UBA_RECORD_NUMBER	NUMBER		Undo record number of the current undo block being applied for rollback
TXN_START_SCN	NUMBER		Start SCN of the quarantined transaction
INCIDENT_TIME	VARCHAR2(64)		Time at which the incident occurred

Note: This view is available starting with Oracle AI Database 26ai.

See Also: “V$FAST_START_TRANSACTIONS”