9.119 V$TRANSACTION
V$TRANSACTION
lists the active transactions in the system.
Column | Datatype | Description |
---|---|---|
|
|
Address of the transaction state object |
|
|
Undo segment number |
|
|
Slot number |
|
|
Sequence number |
|
|
Undo block address (UBA) filenum |
|
|
UBA block number |
|
|
UBA sequence number |
|
|
UBA record number |
|
|
Status |
|
|
Start time (wall clock) |
|
|
Start system change number (SCN) base |
|
|
Start SCN wrap |
|
|
Start extent number |
|
|
Start UBA file number |
|
|
Start UBA block number |
|
|
Start UBA sequence number |
|
|
Start UBA record number |
|
|
User session object address |
|
|
Flag |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Name of a named transaction |
|
|
Previous transaction undo segment number |
|
|
Previous transaction slot number |
|
|
Previous transaction sequence number |
|
|
Rollback segment number of the parent XID |
|
|
Slot number of the parent XID |
|
|
Sequence number of the parent XID |
|
|
This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in |
|
|
This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in |
|
|
Number of undo blocks used |
|
|
Number of undo records used |
|
|
Logical I/O |
|
|
Physical I/O |
|
|
Consistent gets |
|
|
Consistent changes |
|
|
Start time (wall clock) |
|
|
Dependent SCN base |
|
|
Dependent SCN wrap |
|
|
Start SCN |
|
|
Dependent SCN |
|
|
Transaction XID |
|
|
Previous transaction XID |
|
|
Parent transaction XID |
|
|
The ID of the container to which the data pertains. Possible values include:
|