select
  inst_id,                                 -- INST_ID NUMBER
  log_id,                                  -- LOG_ID NUMBER
  filename,                                -- FILENAME VARCHAR2(513)
  low_time,                                -- LOW_TIME NUMBER
  next_time,                               -- NEXT_TIME NUMBER
  db_id,                                   -- DB_ID NUMBER
  db_name,                                 -- DB_NAME VARCHAR2(8)
  reset_scnwrp,                            -- RESET_SCNWRP NUMBER
  reset_scnbas,                            -- RESET_SCNBAS NUMBER
  reset_scn_time,                          -- RESET_SCN_TIME NUMBER
  thread_id,                               -- THREAD_ID NUMBER
  thread_sqn,                              -- THREAD_SQN NUMBER
  low_scnwrp,                              -- LOW_SCNWRP NUMBER
  low_scnbas,                              -- LOW_SCNBAS NUMBER
  next_scnwrp,                             -- NEXT_SCNWRP NUMBER
  next_scnbas,                             -- NEXT_SCNBAS NUMBER
  decode(                                  -- FILE_STATE VARCHAR2(13)
    state, 0, 'FILE_NOT_OPEN', 1, 'FILE_OPEN', 2, 'DONE') 
from
  x$logmnr_logfile