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 |