select
  SCN,                                     -- SCN NUMBER
  START_SCN,                               -- START_SCN NUMBER
  COMMIT_SCN,                              -- 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
  GV$LOGMNR_CONTENTS
where
  inst_id = userenv('instance')