GV$LOGMNR_CONTENTS definition in Oracle 10g / www.oracledba.ru
GV$LOGMNR_CONTENTS
select
INST_ID, -- INST_ID NUMBER
SCN, -- SCN NUMBER
CSCN, -- CSCN NUMBER
TIMESTAMP, -- TIMESTAMP DATE
COMMIT_TIMESTAMP, -- COMMIT_TIMESTAMP DATE
THREAD#, -- THREAD# NUMBER
LOG_ID, -- LOG_ID NUMBER
XIDUSN, -- XIDUSN NUMBER
XIDSLT, -- XIDSLT NUMBER
XIDSQN, -- XIDSQN NUMBER
PXIDUSN, -- PXIDUSN NUMBER
PXIDSLT, -- PXIDSLT NUMBER
PXIDSQN, -- PXIDSQN 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_OBJD#, -- DATA_OBJD# 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)
SESSION#, -- SESSION# NUMBER
SERIAL#, -- SERIAL# NUMBER
USERNAME, -- USERNAME VARCHAR2(30)
SESSION_INFO, -- SESSION_INFO VARCHAR2(4000)
TX_NAME, -- TX_NAME VARCHAR2(256)
ROLLBACK, -- ROLLBACK NUMBER
OPERATION, -- OPERATION VARCHAR2(32)
OPERATION_CODE, -- OPERATION_CODE NUMBER
SQL_REDO, -- SQL_REDO VARCHAR2(4000)
SQL_UNDO, -- SQL_UNDO VARCHAR2(4000)
RS_ID, -- RS_ID VARCHAR2(32)
SEQUENCE#, -- SEQUENCE# NUMBER
SSN, -- SSN NUMBER
CSF, -- CSF NUMBER
INFO, -- INFO VARCHAR2(32)
STATUS, -- STATUS NUMBER
REDO_VALUE, -- REDO_VALUE NUMBER
UNDO_VALUE, -- UNDO_VALUE NUMBER
SQL_COLUMN_TYPE, -- SQL_COLUMN_TYPE VARCHAR2(30)
SQL_COLUMN_NAME, -- SQL_COLUMN_NAME VARCHAR2(30)
REDO_LENGTH, -- REDO_LENGTH NUMBER
REDO_OFFSET, -- REDO_OFFSET NUMBER
UNDO_LENGTH, -- UNDO_LENGTH NUMBER
UNDO_OFFSET, -- UNDO_OFFSET NUMBER
DATA_OBJV#, -- DATA_OBJV# NUMBER
SAFE_RESUME_SCN, -- SAFE_RESUME_SCN NUMBER
XID, -- XID RAW(8)
PXID, -- PXID RAW(8)
AUDIT_SESSIONIDfrom -- AUDIT_SESSIONID NUMBER
x$logmnr_contents
where
ROW_TYPE = 0