V$FAST_START_TRANSACTIONS displays information about the progress of the transactions that Oracle is recovering.
| Column | Datatype | Description | 
|---|---|---|
| USN | NUMBER | Undo segment number of the transaction | 
| SLT | NUMBER | Slot within the rollback segment | 
| SEQ | NUMBER | Incarnation number of the slot | 
| STATE | VARCHAR2(16) | State of the transaction (may be TO BE RECOVERED,RECOVERED, orRECOVERING) | 
| UNDOBLOCKSDONE | NUMBER | Number of undo blocks completed on the transaction | 
| UNDOBLOCKSTOTAL | NUMBER | Total number of undo blocks that need recovery | 
| PID | NUMBER | ID of the current server it has been assigned to | 
| CPUTIME | NUMBER | Time for which recovery has progressed (in seconds) | 
| PARENTUSN | NUMBER | Undo segment number of the parent transaction in PDML | 
| PARENTSLT | NUMBER | Slot of the parent transaction in PDML | 
| PARENTSEQ | NUMBER | Sequence number of the parent transaction in PDML | 
| XID | RAW(8) | Transaction ID | 
| PXID | RAW(8) | Parent transaction ID | 
| RCVSERVERS | NUMBER | Number of servers used in the last recovery | 
See Also:
Oracle Database Performance Tuning Guide