select
  DB_NAME,                                 -- DB_NAME VARCHAR2(9)
  DB_ID,                                   -- DB_ID NUMBER
  DB_CREATED,                              -- DB_CREATED DATE
  TIMESTAMP,                               -- TIMESTAMP DATE
  RESET_SCN,                               -- RESET_SCN NUMBER
  RESET_SCN_TIME,                          -- RESET_SCN_TIME DATE
  DB_VERSION_TIME,                         -- DB_VERSION_TIME DATE
  DB_CHARACTER_SET,                        -- DB_CHARACTER_SET VARCHAR2(30)
  DB_VERSION,                              -- DB_VERSION VARCHAR2(64)
  DB_STATUS,                               -- DB_STATUS VARCHAR2(64)
  DICTIONARY_SCN,                          -- DICTIONARY_SCN NUMBER
  ENABLED_THREAD_MAP,                      -- ENABLED_THREAD_MAP RAW(16)
  DB_TXN_SCN,                              -- DB_TXN_SCN NUMBER
  FILENAME,                                -- FILENAME VARCHAR2(512)
  INFO,                                    -- INFO VARCHAR2(32)
  STATUS                                   -- STATUS NUMBER
from
  GV$LOGMNR_DICTIONARY
where
  inst_id = userenv('instance')