VIEW: SYS.V_$LOGMNR_CONTENTS

Source

View Text - Preformatted

select "SCN","START_SCN","COMMIT_SCN","TIMESTAMP","START_TIMESTAMP","COMMIT_TIMESTAMP","XIDUSN","XIDSLT","XIDSQN","XID","PXIDUSN","PXIDSLT","PXIDSQN","PXID","TX_NAME","OPERATION","OPERATION_CODE","ROLLBACK","SEG_OWNER","SEG_NAME","TABLE_NAME","SEG_TYPE","SEG_TYPE_NAME","TABLE_SPACE","ROW_ID","USERNAME","OS_USERNAME","MACHINE_NAME","AUDIT_SESSIONID","SESSION#","SERIAL#","SESSION_INFO","THREAD#","SEQUENCE#","RBASQN","RBABLK","RBABYTE","UBAFIL","UBABLK","UBAREC","UBASQN","ABS_FILE#","REL_FILE#","DATA_BLK#","DATA_OBJ#","DATA_OBJV#","DATA_OBJD#","SQL_REDO","SQL_UNDO","RS_ID","SSN","CSF","INFO","STATUS","REDO_VALUE","UNDO_VALUE","SAFE_RESUME_SCN","CSCN","OBJECT_ID","EDITION_NAME","CLIENT_ID","SRC_CON_NAME","SRC_CON_ID","SRC_CON_UID","SRC_CON_DBID","SRC_CON_GUID","CON_ID" from v$logmnr_contents

View Text - HTML Formatted

SELECT "SCN"
, "START_SCN"
, "COMMIT_SCN"
, "TIMESTAMP"
, "START_TIMESTAMP"
, "COMMIT_TIMESTAMP"
, "XIDUSN"
, "XIDSLT"
, "XIDSQN"
, "XID"
, "PXIDUSN"
, "PXIDSLT"
, "PXIDSQN"
, "PXID"
, "TX_NAME"
, "OPERATION"
, "OPERATION_CODE"
, "ROLLBACK"
, "SEG_OWNER"
, "SEG_NAME"
, "TABLE_NAME"
, "SEG_TYPE"
, "SEG_TYPE_NAME"
, "TABLE_SPACE"
, "ROW_ID"
, "USERNAME"
, "OS_USERNAME"
, "MACHINE_NAME"
, "AUDIT_SESSIONID"
, "SESSION#"
, "SERIAL#"
, "SESSION_INFO"
, "THREAD#"
, "SEQUENCE#"
, "RBASQN"
, "RBABLK"
, "RBABYTE"
, "UBAFIL"
, "UBABLK"
, "UBAREC"
, "UBASQN"
, "ABS_FILE#"
, "REL_FILE#"
, "DATA_BLK#"
, "DATA_OBJ#"
, "DATA_OBJV#"
, "DATA_OBJD#"
, "SQL_REDO"
, "SQL_UNDO"
, "RS_ID"
, "SSN"
, "CSF"
, "INFO"
, "STATUS"
, "REDO_VALUE"
, "UNDO_VALUE"
, "SAFE_RESUME_SCN"
, "CSCN"
, "OBJECT_ID"
, "EDITION_NAME"
, "CLIENT_ID"
, "SRC_CON_NAME"
, "SRC_CON_ID"
, "SRC_CON_UID"
, "SRC_CON_DBID"
, "SRC_CON_GUID"
, "CON_ID"
FROM V$LOGMNR_CONTENTS