select
  OWNER,                                   -- OWNER VARCHAR2(30)
  SEGMENT_NAME,                            -- SEGMENT_NAME VARCHAR2(81)
  PARTITION_NAME,                          -- PARTITION_NAME VARCHAR2(30)
  SEGMENT_TYPE,                            -- SEGMENT_TYPE VARCHAR2(18)
  SEGMENT_TYPE_ID,                         -- SEGMENT_TYPE_ID NUMBER
  TABLESPACE_ID,                           -- TABLESPACE_ID NUMBER
  TABLESPACE_NAME,                         -- TABLESPACE_NAME VARCHAR2(30)
  BLOCKSIZE,                               -- BLOCKSIZE NUMBER
  HEADER_FILE,                             -- HEADER_FILE NUMBER
  HEADER_BLOCK,                            -- HEADER_BLOCK NUMBER
  BYTES,                                   -- BYTES NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  EXTENTS,                                 -- EXTENTS NUMBER
  INITIAL_EXTENT,                          -- INITIAL_EXTENT NUMBER
  NEXT_EXTENT,                             -- NEXT_EXTENT NUMBER
  MIN_EXTENTS,                             -- MIN_EXTENTS NUMBER
  MAX_EXTENTS,                             -- MAX_EXTENTS NUMBER
  PCT_INCREASE,                            -- PCT_INCREASE NUMBER
  FREELISTS,                               -- FREELISTS NUMBER
  FREELIST_GROUPS,                         -- FREELIST_GROUPS NUMBER
  RELATIVE_FNO,                            -- RELATIVE_FNO NUMBER
  BUFFER_POOL_ID,                          -- BUFFER_POOL_ID NUMBER
  SEGMENT_FLAGS,                           -- SEGMENT_FLAGS NUMBER
  SEGMENT_OBJD                             -- SEGMENT_OBJD NUMBER
from
  GV$LOGMNR_OBJECT_SEGMENTS
where
  inst_id = userenv('instance')