select
  OWNER,                                   -- OWNER VARCHAR2(30)
  OBJECT_NAME,                             -- OBJECT_NAME VARCHAR2(30)
  SUBOBJECT_NAME,                          -- SUBOBJECT_NAME VARCHAR2(30)
  OBJECT_ID,                               -- OBJECT_ID NUMBER
  DATA_OBJECT_ID,                          -- DATA_OBJECT_ID NUMBER
  OBJECT_TYPE,                             -- OBJECT_TYPE VARCHAR2(18)
  CREATED,                                 -- CREATED DATE
  LAST_DDL_TIME,                           -- LAST_DDL_TIME DATE
  TIMESTAMP,                               -- TIMESTAMP VARCHAR2(19)
  STATUS,                                  -- STATUS VARCHAR2(7)
  TEMPORARY,                               -- TEMPORARY VARCHAR2(1)
  GENERATED,                               -- GENERATED VARCHAR2(1)
  SECONDARY                                -- SECONDARY VARCHAR2(1)
from
  gv$logmnr_dba_objects
where
  inst_id = userenv('instance')