|
SCN
|
NUMBER
|
System change number (SCN) when the redo record was generated
|
|
CSCN
|
NUMBER
|
|
|
TIMESTAMP
|
DATE
|
Timestamp
|
|
COMMIT_TIMESTAMP
|
DATE
|
|
|
THREAD#
|
NUMBER
|
Number of the thread which generated the redo record
|
|
LOG_ID
|
NUMBER
|
Number of the log file which contains the redo record. This number is generated by LogMiner to uniquely identify a log, and corresponds to the LOG_ID column in V$LOGMNR_FILES.
|
|
XIDUSN
|
NUMBER
|
Transaction ID undo segment number of the transaction which generated the change
|
|
XIDSLT
|
NUMBER
|
Transaction ID slot number of the transaction which generated the change
|
|
XIDSQN
|
NUMBER
|
Transaction ID sequence number of the transaction which generated the change
|
|
RBASQN
|
NUMBER
|
RBA sequence number of the log that contained this redo record
|
|
RBABLK
|
NUMBER
|
RBA block number within the log file
|
|
RBABYTE
|
NUMBER
|
RBA byte offset within the block
|
|
UBAFIL
|
NUMBER
|
UBA file number identifying the file containing the undo block
|
|
UBABLK
|
NUMBER
|
UBA block number for the undo block
|
|
UBAREC
|
NUMBER
|
UBA record index within the undo block
|
|
UBASQN
|
NUMBER
|
UBA undo block sequence number
|
|
ABS_FILE#
|
NUMBER
|
Data block absolute file number of the block changed by the transaction
|
|
REL_FILE#
|
NUMBER
|
Data block relative file number. The file number is relative to the tablespace of the object.
|
|
DATA_BLK#
|
NUMBER
|
Data block number within the file
|
|
DATA_OBJ#
|
NUMBER
|
Data block object number identifying the object
|
|
DATA_DOBJ#
|
NUMBER
|
Data block data object number identifying the object within the tablespace
|
|
SEG_OWNER
|
VARCHAR2(30)
|
Owner of the segment
|
|
SEG_NAME
|
VARCHAR2(81)
|
Name of the segment
|
|
SEG_TYPE
|
NUMBER
|
Segment type
|
|
SEG_TYPE_NAME
|
VARCHAR2(32)
|
Segment type name
|
|
TABLE_SPACE
|
VARCHAR2(30)
|
Tablespace name
|
|
ROW_ID
|
VARCHAR2(18)
|
Row ID
|
|
SESSION#
|
NUMBER
|
Session number of the session which generated the redo. A NULL value is reported if the session number is not available from the redo log.
|
|
SERIAL#
|
NUMBER
|
Serial number of the session which generated the redo. The session number and serial # can be used to uniquely identify the Oracle session. A NULL value is reported if the session number is not available from the redo log.
|
|
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.
|
