GV$LOGMNR_CONTENTS definition in Oracle Database 11.2
GV$LOGMNR_CONTENTS
select
INST_ID, -- INST_ID NUMBER
SCN, -- SCN NUMBER
START_SCN, -- START_SCN NUMBER
CSCN, -- COMMIT_SCN NUMBER
TIMESTAMP, -- TIMESTAMP DATE
START_TIMESTAMP, -- START_TIMESTAMP DATE
COMMIT_TIMESTAMP, -- COMMIT_TIMESTAMP DATE
XIDUSN, -- XIDUSN NUMBER
XIDSLT, -- XIDSLT NUMBER
XIDSQN, -- XIDSQN NUMBER
XID, -- XID RAW(8)
PXIDUSN, -- PXIDUSN NUMBER
PXIDSLT, -- PXIDSLT NUMBER
PXIDSQN, -- PXIDSQN NUMBER
PXID, -- PXID RAW(8)
TX_NAME, -- TX_NAME VARCHAR2(256)
OPERATION, -- OPERATION VARCHAR2(32)
OPERATION_CODE, -- OPERATION_CODE NUMBER
ROLLBACK, -- ROLLBACK NUMBER
SEG_OWNER, -- SEG_OWNER VARCHAR2(32)
SEG_NAME, -- SEG_NAME VARCHAR2(256)
TABLE_NAME, -- TABLE_NAME VARCHAR2(32)
SEG_TYPE, -- SEG_TYPE NUMBER
SEG_TYPE_NAME, -- SEG_TYPE_NAME VARCHAR2(32)
TABLE_SPACE, -- TABLE_SPACE VARCHAR2(32)
ROW_ID, -- ROW_ID VARCHAR2(18)
USERNAME, -- USERNAME VARCHAR2(30)
OS_USERNAME, -- OS_USERNAME VARCHAR2(4000)
MACHINE_NAME, -- MACHINE_NAME VARCHAR2(4000)
AUDIT_SESSIONID, -- AUDIT_SESSIONID NUMBER
SESSION#, -- SESSION# NUMBER
SERIAL#, -- SERIAL# NUMBER
SESSION_INFO, -- SESSION_INFO VARCHAR2(4000)
THREAD#, -- THREAD# NUMBER
SEQUENCE#, -- SEQUENCE# NUMBER
RBASQN, -- RBASQN NUMBER
RBABLK, -- RBABLK NUMBER
RBABYTE, -- RBABYTE NUMBER
UBAFIL, -- UBAFIL NUMBER
UBABLK, -- UBABLK NUMBER
UBAREC, -- UBAREC NUMBER
UBASQN, -- UBASQN NUMBER
ABS_FILE#, -- ABS_FILE# NUMBER
REL_FILE#, -- REL_FILE# NUMBER
DATA_BLK#, -- DATA_BLK# NUMBER
DATA_OBJ#, -- DATA_OBJ# NUMBER
DATA_OBJV#, -- DATA_OBJV# NUMBER
DATA_OBJD#, -- DATA_OBJD# NUMBER
SQL_REDO, -- SQL_REDO VARCHAR2(4000)
SQL_UNDO, -- SQL_UNDO VARCHAR2(4000)
RS_ID, -- RS_ID VARCHAR2(32)
SSN, -- SSN NUMBER
CSF, -- CSF NUMBER
INFO, -- INFO VARCHAR2(32)
STATUS, -- STATUS NUMBER
REDO_VALUE, -- REDO_VALUE NUMBER
UNDO_VALUE, -- UNDO_VALUE NUMBER
SAFE_RESUME_SCN, -- SAFE_RESUME_SCN NUMBER
CSCN, -- CSCN NUMBER
OBJECT_ID, -- OBJECT_ID RAW(16)
EDITION_NAME, -- EDITION_NAME VARCHAR2(30)
CLIENT_ID -- CLIENT_ID VARCHAR2(64)
from
x$logmnr_contents
where
ROW_TYPE = 0