GV$LOGMNR_LOGS

select
INST_ID,                 -- INST_ID NUMBER
LOG_ID,                  -- LOG_ID NUMBER
FILENAME,                -- FILENAME VARCHAR2(513)
LOW_TIME,                -- LOW_TIME DATE
HIGH_TIME,               -- HIGH_TIME DATE
DB_ID,                   -- DB_ID NUMBER
DB_NAME,                 -- DB_NAME VARCHAR2(8)
RESET_SCNBAS,            -- RESET_SCN NUMBER
RESET_SCN_TIME,          -- RESET_SCN_TIME DATE
THREAD_ID,               -- THREAD_ID NUMBER
THREAD_SQN,              -- THREAD_SQN NUMBER
LOW_SCNBAS,              -- LOW_SCN NUMBER
NEXT_SCNBAS,             -- NEXT_SCN NUMBER
INFO,                    -- INFO VARCHAR2(32)
STATUS                   -- STATUS NUMBER
from
x$logmnr_logs
home |  up  |  mailbox