V$LOGMNR_CONTENTS

This view contains log history information.

When a SELECT statement is executed against the V$LOGMNR_CONTENTS view, the archive redo log files are read sequentially. Translated records from the redo log files are returned as rows in the V$LOGMNR_CONTENTS view. This continues until either the filter criteria specified at startup (EndTime or endScn) are met or the end of the archive log file is reached.

Column	Datatype	Description
`SCN`	`NUMBER`	System change number (SCN) when the redo record was generated
`CSCN`	`NUMBER`	System change number (SCN) when the transaction committed; only meaningful if the `COMMITTED_DATA_ONLY` option was chosen in a `DBMS_LOGMNR.START_LOGMNR()` invocation
`TIMESTAMP`	`DATE`	Timestamp when the redo record was generated
`COMMIT_TIMESTAMP`	`DATE`	Timestamp when the transaction committed; only meaningful if the `COMMITTED_DATA_ONLY` option was chosen in a `DBMS_LOGMNR.START_LOGMNR()` invocation
`THREAD#`	`NUMBER`	Number of the thread which generated the redo record
`LOG_ID`	`NUMBER`	This column is deprecated.
`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
`PXIDUSN`	`NUMBER`	Parent transaction ID undo segment number of a PDML transaction
`PXIDSLT`	`NUMBER`	Parent transaction ID slot number of a PDML transaction
`PXIDSQN`	`NUMBER`	Parent transaction ID sequence number of a PDML transaction
`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_OBJD#`	`NUMBER`	Data block data object number identifying the object within the tablespace
`SEG_OWNER`	`VARCHAR2(32)`	Owner of the segment
`SEG_NAME`	`VARCHAR2(256)`	Name of the segment
`TABLE_NAME`	`VARCHAR2(32)`	Name of the table if the type is a table
`SEG_TYPE`	`NUMBER`	Segment type
`SEG_TYPE_NAME`	`VARCHAR2(32)`	Segment type name
`TABLE_SPACE`	`VARCHAR2(32)`	Tablespace name
`ROW_ID`	`VARCHAR2(18)`	Row ID
`SESSION#`	`NUMBER`	Session number of the session which generated the redo
`SERIAL#`	`NUMBER`	Serial number of the session which generated the redo
`USERNAME`	`VARCHAR2(30)`	Name of the user who executed the transaction
`SESSION_INFO`	`VARCHAR2(4000)`	Information about the database session that executed the transaction
`TX_NAME`	`VARCHAR2(256)`	Name of the transaction if it is a named transaction
`ROLLBACK`	`NUMBER`	Rollback request
`OPERATION`	`VARCHAR2(32)`	Operation
`OPERATION_CODE`	`NUMBER`	Operation code
`SQL_REDO`	`VARCHAR2(4000)`	SQL redo
`SQL_UNDO`	`VARCHAR2(4000)`	SQL undo
`RS_ID`	`VARCHAR2(32)`	Record set ID
`SEQUENCE#`	`NUMBER`	Sequence number
`SSN`	`NUMBER`	SQL sequence number
`CSF`	`NUMBER`	Continuation SQL flag
`INFO`	`VARCHAR2(32)`	Informational message
`STATUS`	`NUMBER`	Status
`REDO_VALUE`	`NUMBER`	Used as input to the `DBMS_LOGMNR.MINE_VALUE()` and `DBMS_LOGMNR.COLUMN_PRESENT()` functions
`UNDO_VALUE`	`NUMBER`	Used as input to the `DBMS_LOGMNR.MINE_VALUE()` and `DBMS_LOGMNR.COLUMN_PRESENT()` functions
`SQL_COLUMN_TYPE`	`VARCHAR2(30)`	This column is deprecated.
`SQL_COLUMN_NAME`	`VARCHAR2(30)`	This column is deprecated.
`REDO_LENGTH`	`NUMBER`	This column is deprecated.
`REDO_OFFSET`	`NUMBER`	This column is deprecated.
`UNDO_LENGTH`	`NUMBER`	This column is deprecated.
`UNDO_OFFSET`	`NUMBER`	This column is deprecated.
`DATA_OBJV#`	`NUMBER`	Version number of the object `DATA_OBJ#`
`SAFE_RESUME_SCN`	`NUMBER`	Reserved for future use
`XID`	`RAW(8)`	Full transaction handle
`PXID`	`RAW(8)`	Full transaction handle of the parent transaction
`AUDIT_SESSIONID`	`NUMBER`	Audit session ID of the transaction