GV$LOGMNR_LOGFILE

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
home |  up  |  mailbox