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. |