select
  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
  file_state                               -- FILE_STATE VARCHAR2(13)
from
  gv$logmnr_logfile
where
  inst_id = userenv('instance')