select
  u.inst_id,                               -- INST_ID NUMBER
  u.name,                                  -- OWNER VARCHAR2(30)
  o.name,                                  -- OBJECT_NAME VARCHAR2(30)
  o.subname,                               -- SUBOBJECT_NAME VARCHAR2(30)
  o.obj#,                                  -- OBJECT_ID NUMBER
  o.dataobj#,                              -- DATA_OBJECT_ID NUMBER
  decode(                                  -- OBJECT_TYPE VARCHAR2(18)
    o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 46, 'RULE SET', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 59, 'RULE', 60, 'CAPTURE', 61, 'APPLY', 62, 'EVALUATION CONTEXT', 66, 'JOB', 67, 'PROGRAM', 68, 'JOB CLASS', 69, 'WINDOW', 72, 'WINDOW GROUP', 74, 'SCHEDULE', 79, 'CHAIN', 81, 'FILE GROUP', 'UNDEFINED'),
  o.ctime,                                 -- CREATED DATE
  o.mtime,                                 -- LAST_DDL_TIME DATE
  to_char(                                 -- TIMESTAMP VARCHAR2(19)
    o.stime, 'YYYY-MM-DD:HH24:MI:SS'),
  decode(                                  -- STATUS VARCHAR2(7)
    o.status, 0, 'N/A', 1, 'VALID', 'INVALID'),
  decode(                                  -- TEMPORARY VARCHAR2(1)
    bitand(o.flags, 2), 0, 'N', 2, 'Y', 'N'),
  decode(                                  -- GENERATED VARCHAR2(1)
    bitand(o.flags, 4), 0, 'N', 4, 'Y', 'N'),
  decode(                                  -- SECONDARY VARCHAR2(1)
    bitand(o.flags, 16), 0, 'N', 16, 'Y', 'N') 
from
  x$logmnr_obj$ o,
  x$logmnr_user$ u
where
  o.owner# = u.user# and o.linkname is null and (o.type# not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (o.type# = 1 and 1 = (
      select
        1
      from
        x$logmnr_ind$ i
      where
        i.obj# = o.obj# and i.type# in (1, 2, 3, 4, 6, 7, 9)))) and o.name != '_NEXT_OBJECT' and o.name != '_default_auditing_options_'