|
SCN |
NUMBER(15) |
The system change number |
|
CSN |
NUMBER |
|
|
TIMESTAMP |
DATE |
The timestamp |
|
COMMIT_TIMESTAMP |
DATE |
|
|
THREAD# |
NUMBER |
The thread number |
|
LOG_ID |
NUMBER |
The log ID |
|
XIDUSN |
NUMBER |
The transaction ID undo segment number |
|
XIDSLT |
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 |
|
SEG_TYPE_NAME |
VARCHAR2(32) |
The segment type name |
|
TABLE_SPACE |
VARCHAR2(30) |
The tablespace name of segment |
|
ROW_ID |
VARCHAR2(18) |
The row ID |
|
SESSION# |
NUMBER |
The session number |
|
SERIAL# |
NUMBER |
The serial number |
|
USERNAME |
VARCHAR2(30) |
The user name |
|
SESSION_INFO |
VARCHAR2(4000) |
Session information |
|
ROLLBACK |
NUMBER |
The rollback request |
|
OPERATION |
VARCHAR2(30) |
The operation |
|
OPERATION_CODE |
NUMBER |
The operation code |
|
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 |
|
REDO_VALUE |
RAW(4) |
|
|
UNDO_VALUE |
RAW(4) |
|
|
SQL_COLUMN_TYPE |
VARCHAR2(32) |
Type of data in the SQL_REDO and SQL_UNDO columns |
|
SQL_COLUMN_NAME |
VARCHAR2(32) |
The name of the LOB or LONG columns |
|
REDO_LENGTH |
NUMBER |
The length of the data value in the SQL_REDO column. |
|
REDO_OFFSET |
NUMBER |
The length of the data value in the SQL_REDO column |
|
UNDO_LENGTH |
NUMBER |
The length of the data value in the SQL_UNDO column |
|
UNDO_OFFSET |
NUMBER |
If SQL_COLUMN_TYPE is LOB_COLUMN or LONG_COLUMN then this column contains the byte offset of the SQL_UNDO column data in the column indicated by SQL_COLUMN_NAME. Zero by default. |
