V$FAST_START_TRANSACTIONS
displays information about the progress of the transactions that Oracle is recovering.
Column | Datatype | Description |
---|---|---|
|
|
Undo segment number of the transaction |
|
|
Slot within the rollback segment |
|
|
Incarnation number of the slot |
|
|
State of the transaction (may be |
|
|
Number of undo blocks completed on the transaction |
|
|
Total number of undo blocks that need recovery |
|
|
ID of the current server it has been assigned to |
|
|
Time for which recovery has progressed (in seconds) |
|
|
Undo segment number of the parent transaction in PDML |
|
|
Slot of the parent transaction in PDML |
|
|
Sequence number of the parent transaction in PDML |
|
|
Transaction ID |
|
|
Parent transaction ID |
|
|
Number of servers used in the last recovery |
|
|
The ID of the container to which the data pertains. Possible values include:
|