select
  userenv('instance'),                     -- INST_ID NUMBER
  s.OWNER,                                 -- OWNER VARCHAR2(30)
  s.SEGMENT_NAME,                          -- SEGMENT_NAME VARCHAR2(81)
  s.PARTITION_NAME,                        -- PARTITION_NAME VARCHAR2(30)
  s.SEGMENT_TYPE,                          -- SEGMENT_TYPE VARCHAR2(18)
  s.SEGMENT_TYPE_ID,                       -- SEGMENT_TYPE_ID NUMBER
  s.TABLESPACE_ID,                         -- TABLESPACE_ID NUMBER
  s.TABLESPACE_NAME,                       -- TABLESPACE_NAME VARCHAR2(30)
  s.BLOCKSIZE,                             -- BLOCKSIZE NUMBER
  s.HEADER_FILE,                           -- HEADER_FILE NUMBER
  s.HEADER_BLOCK,                          -- HEADER_BLOCK NUMBER
  s.BYTES,                                 -- BYTES NUMBER
  s.BLOCKS,                                -- BLOCKS NUMBER
  s.EXTENTS,                               -- EXTENTS NUMBER
  s.INITIAL_EXTENT,                        -- INITIAL_EXTENT NUMBER
  s.NEXT_EXTENT,                           -- NEXT_EXTENT NUMBER
  s.MIN_EXTENTS,                           -- MIN_EXTENTS NUMBER
  s.MAX_EXTENTS,                           -- MAX_EXTENTS NUMBER
  s.PCT_INCREASE,                          -- PCT_INCREASE NUMBER
  s.FREELISTS,                             -- FREELISTS NUMBER
  s.FREELIST_GROUPS,                       -- FREELIST_GROUPS NUMBER
  s.RELATIVE_FNO,                          -- RELATIVE_FNO NUMBER
  s.BUFFER_POOL_ID,                        -- BUFFER_POOL_ID NUMBER
  s.SEGMENT_FLAGS,                         -- SEGMENT_FLAGS NUMBER
  s.SEGMENT_OBJD                           -- SEGMENT_OBJD NUMBER
from
  v$logmnr_sys_dba_segs s,
  v$logmnr_dba_objects o
where
  s.segment_name = o.object_name and s.segment_type = o.object_type