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)
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(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 RAW(4)
UNDO_VALUE,              -- UNDO_VALUE RAW(4)
SQL_COLUMN_TYPE,         -- SQL_COLUMN_TYPE VARCHAR2(32)
SQL_COLUMN_NAME,         -- SQL_COLUMN_NAME VARCHAR2(32)
REDO_LENGTH,             -- REDO_LENGTH NUMBER
REDO_OFFSET,             -- REDO_OFFSET NUMBER
UNDO_LENGTH,             -- UNDO_LENGTH NUMBER
UNDO_OFFSET              -- UNDO_OFFSET NUMBER
from
x$logmnr_contents 
where
ROW_TYPE = 0
home |  up  |  mailbox