6.295 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 Database 23ai.