|
ADDR |
RAW(4) |
Address of transaction state object |
|
XIDUSN |
NUMBER |
Undo segment number |
|
XIDSLOT |
NUMBER |
Slot number |
|
XIDSQN |
NUMBER |
Sequence number |
|
UBAFIL |
NUMBER |
Undo block address (UBA) filenum |
|
UBABLK |
NUMBER |
UBA block number |
|
UBASQN |
NUMBER |
UBA sequence number |
|
UBAREC |
NUMBER |
UBA record number |
|
STATUS |
VARCHAR2(16) |
Status |
|
START_TIME |
VARCHAR2(20) |
Start time (wall clock) |
|
START_SCNB |
NUMBER |
Start system change number (SCN) base |
|
START_SCNW |
NUMBER |
Start SCN wrap |
|
START_UEXT |
NUMBER |
Start extent number |
|
START_UBAFIL |
NUMBER |
Start UBA file number |
|
START_UBABLK |
NUMBER |
Start UBA block number |
|
START_UBASQN |
NUMBER |
Start UBA sequence number |
|
START_UBAREC |
NUMBER |
Start UBA record number |
|
SES_ADDR |
RAW(4) |
User session object address |
|
FLAG |
NUMBER |
Flag |
|
SPACE |
VARCHAR2(3) |
"Yes", if a space transaction |
|
RECURSIVE |
VARCHAR2(3) |
"Yes", if a recursive transaction |
|
NOUNDO |
VARCHAR2(3) |
"Yes" if a no undo transaction |
|
PTX |
VARCHAR 2(3) |
YES if parallel transaction, otherwise set to NO |
|
PRV_XIDUSN |
NUMBER |
Previous transaction undo segment number |
|
PRV_XIDSLT |
NUMBER |
Previous transaction slot number |
|
PRV_XIDSQN |
NUMBER |
Previous transaction sequence number |
|
PTX_XIDUSN |
NUMBER |
Rollback segment number of the parent XID |
|
PTX_XIDSLT |
NUMBER |
Slot number of the parent XID |
|
PTX_XIDSQN |
NUMBER |
Sequence number of the parent XID |
|
DSCN_B |
NUMBER |
Dependent SCN base |
|
DSCN_W |
NUMBER |
Dependent SCN wrap |
|
USED_UBLK |
NUMBER |
Number of undo blocks used |
|
USED_UREC |
NUMBER |
Number of undo records used |
|
LOG_IO |
NUMBER |
Logical I/O |
|
PHY_IO |
NUMBER |
Physical I/O |
|
CR_GET |
NUMBER |
Consistent gets |
|
CR_CHANGE |
NUMBER |
Consistent changes |
