GV$LOGMNR_CONTENTS definition in Oracle 8i / www.oracledba.ru
GV$LOGMNR_CONTENTS
select
INST_ID, -- INST_ID NUMBER
SCN, -- SCN NUMBER
TIMESTAMP, -- TIMESTAMP DATE
THREAD#, -- THREAD# NUMBER
LOG_ID, -- LOG_ID NUMBER
XIDUSN, -- XIDUSN NUMBER
XIDSLT, -- XIDSLT NUMBER
XIDSQN, -- XIDSQN 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(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(19)
SESSION#, -- SESSION# NUMBER
SERIAL#, -- SERIAL# NUMBER
USERNAME, -- USERNAME VARCHAR2(32)
SESSION_INFO, -- SESSION_INFO VARCHAR2(4000)
ROLLBACK, -- ROLLBACK NUMBER
OPERATION, -- OPERATION VARCHAR2(32)
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
PH1_NAME, -- PH1_NAME VARCHAR2(32)
PH1_REDO, -- PH1_REDO VARCHAR2(4000)
PH1_UNDO, -- PH1_UNDO VARCHAR2(4000)
PH2_NAME, -- PH2_NAME VARCHAR2(32)
PH2_REDO, -- PH2_REDO VARCHAR2(4000)
PH2_UNDO, -- PH2_UNDO VARCHAR2(4000)
PH3_NAME, -- PH3_NAME VARCHAR2(32)
PH3_REDO, -- PH3_REDO VARCHAR2(4000)
PH3_UNDO, -- PH3_UNDO VARCHAR2(4000)
PH4_NAME, -- PH4_NAME VARCHAR2(32)
PH4_REDO, -- PH4_REDO VARCHAR2(4000)
PH4_UNDO, -- PH4_UNDO VARCHAR2(4000)
PH5_NAME, -- PH5_NAME VARCHAR2(32)
PH5_REDO, -- PH5_REDO VARCHAR2(4000)
PH5_UNDO -- PH5_UNDO VARCHAR2(4000)
from
x$logmnr_contents
where
ROW_TYPE = 0
