SCN |
NUMBER(15) |
The system change number |
TIMESTAMP |
DATE |
The timestamp |
THREAD# |
NUMBER |
The thread number |
LOG_ID |
NUMBER |
The log ID |
XIDUSN |
NUMBER |
The transaction ID undo segment number |
XIDSLOT |
NUMBER |
The transaction ID slot number |
XIDSQN |
NUMBER |
The transaction ID log sequence number |
RBASQN |
NUMBER |
The RBA log sequence number |
RBABLK |
NUMBER |
The RBA block number |
RBABYTE |
NUMBER |
The RBA byte offset |
UBAFIL |
NUMBER |
The UBA file number |
UBABLK |
NUMBER |
The UBA block number |
UBAREC |
NUMBER |
The UBA record index |
UBASQN |
NUMBER |
The UBA undo block sequence number |
ABS_FILE# |
NUMBER |
The data block absolute file number |
REL_FILE# |
NUMBER |
The data block relative file number |
DATA_BLK# |
NUMBER |
The data block number |
DATA_OBJ# |
NUMBER |
The data block object number |
DATA_DOBJ# |
NUMBER |
The data block data object number |
SEG_OWNER |
VARCHAR2(30) |
The owner name of the segment |
SEG_NAME |
VARCHAR2(81) |
The segment name |
SEG_TYPE |
NUMBER |
The segment type |
TABLE_SPACE_NAME |
VARCHAR2(30) |
The tablespace name of segment |
ROW_ID |
VARCHAR2(18) |
The row ID |
SESSION# |
NUMBER |
The session number |
SERIAL# |
NUMBER |
The serial number |
USER_NAME |
VARCHAR2(30) |
The user name |
SESSION_INFO |
VARCHAR2(4000) |
Session information |
ROLLBACK |
NUMBER |
The rollback request |
OPERATION |
VARCHAR2(30) |
The operation |
SQL_REDO |
VARCHAR2(4000) |
SQL redo |
SQL_UNDO |
VARCHAR2(4000) |
SQL undo |
RS_ID |
VARCHAR2(30) |
Record set ID |
SSN |
NUMBER |
SQL sequence number |
CSF |
NUMBER |
Continuation SQL flag |
INFO |
VARCHAR2(32) |
Informational message |
STATUS |
VARCHAR2 (16) |
The status |