V$LOGMNR_CONTENTS Data Dictionary View
Columns
___________________________
SCN
CSCN
TIMESTAMP
COMMIT_TIMESTAMP
THREAD#
LOG_ID
XIDUSN
XIDSLT
XIDSQN
PXIDUSN
PXIDSLT
PXIDSQN
RBASQN
RBABLK
RBABYTE
UBAFIL
UBABLK
UBAREC
UBASQN
ABS_FILE#
REL_FILE#
DATA_BLK#
DATA_OBJ#
DATA_OBJD#
SEG_OWNER
SEG_NAME
SEG_TYPE
SEG_TYPE_NAME
TABLE_SPACE
ROW_ID
SESSION#
SERIAL#
USERNAME
SESSION_INFO
TX_NAME
ROLLBACK
OPERATION
OPERATION_CODE
SQL_REDO
SQL_UNDO
RS_ID
SEQUENCE#
SSN
CSF
INFO
STATUS
REDO_VALUE
UNDO_VALUE
SQL_COLUMN_TYPE
SQL_COLUMN_NAME
REDO_LENGTH
REDO_OFFSET
UNDO_LENGTH
UNDO_OFFSET
V$LOGMNR_DICTIONARY Data Dictionary View Columns
___________________________
TIMESTAMP
DB_ID
DB_NAME
FILENAME
DICTIONARY_SCN
RESET_SCN
RESET_SCN_TIME
ENABLED_THREAD_MAP
INFO
STATUS
V$LOGMNR_LOGFILE Data Dictionary View Columns
___________________________
LOG_ID
FILENAME
LOW_TIME
NEXT_TIME
DB_ID
DB_NAME
RESET_SCNWRP
RESET_SCNBAS
RESET_SCN_TIME
THREAD_ID
THREAD_SQN
LOW_SCNWRP
LOW_SCNBAS
NEXT_SCNWRP
NEXT_SCNBAS
FILE_STATE
V$LOGMNR_LOGS Data Dictionary View Columns
___________________________
LOG_ID
FILENAME
LOW_TIME
HIGH_TIME
DB_ID
DB_NAME
RESET_SCN
RESET_SCN_TIME
THREAD_ID
THREAD_SQN
LOW_SCN
NEXT_SCN
DICTIONARY_BEGIN
DICTIONARY_END
INFO
STATUS
V$LOGMNR_PARAMETERS Data Dictionary View Columns
___________________________
END_SCN
INFO
STATUS
START_DATE
END_DATE
START_SCN
V$LOGMNR_PROCESS Data Dictionary View Columns
___________________________
PID
SPID
ROLE
USERNAME
SERIAL#
LATCHWAIT
LATCHSPIN
V$LOGMNR_REGION Data Dictionary View Columns
___________________________
MEMSTATE
STATE
OWNING_PROCESS
V$LOGMNR_SESSION Data Dictionary View Columns
___________________________
SESSION_ID
SESSION_NAME
SESSION_STATE
START_SCNWRP
START_SCNBAS
END_SCNWRP
END_SCNBAS
SPILL_SCNWRP
SPILL_SCNBAS
REQUIRED_SLAVE_NUM
EAGER_THRESHOLD
STOPMINING_THRESHOLD
MEMORY_SIZE
CLIENT_ID
DB_ID
RESET_SCNWRP
RESET_SCNBAS
CALLBACK_COUNT
SLAVE_COUNT
V$LOGMNR_STATS Data Dictionary View Columns
___________________________
SESSION_ID
NAME
VALUE
V$LOGMNR_TRANSACTION Data Dictionary View Columns
___________________________
XIDUSN
XIDSLT
XIDSQN
COMMIT_SCNWRP
COMMIT_SCNBAS
NUM_CHANGE_RECORD
FLAGS
CHUNK_INDEX
TOTAL_CHUNKS