USN

NUMBER

The undo segment number of the transaction

SLT

NUMBER

The slot within the rollback segment

SEQ

NUMBER

The incarnation number of the slot

STATE

VARCHAR2(16)

The state of the transaction may be TO BE RECOVERED, RECOVERED, or RECOVERING

UNDOBLOCKSDONE

NUMBER

The number of undo blocks completed on this transaction

UNDOBLOCKSTOTAL

NUMBER

The total number of undo blocks that need recovery

PID

NUMBER

The ID of the current server it has been assigned to

CPUTIME

NUMBER

The time for which recovery has progressed, in seconds

PARENTUSN

NUMBER

The undo segment number of the parent transaction in PDML

PARENTSLT

NUMBER

The slot of the parent transaction in PDML

PARENTSEQ

NUMBER

The sequence number of the parent transaction in PDML