Dynamic Performance (V$) Views, 57 of 179

V$FAST_START_TRANSACTIONS

V$FAST_START_TRANSACTIONS contains information about the progress of the transactions that Oracle is recovering.

See Also:
Oracle8i Backup and Recovery Guide.

Column	Datatype	Description
`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