Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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, or RECOVERING)
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