GV$LOGMNR_SESSION

select
INST_ID,                 -- INST_ID NUMBER
SESSION_ID,              -- SESSION_ID NUMBER
SESSION_NAME,            -- SESSION_NAME VARCHAR2(32)
decode                   -- SESSION_STATE VARCHAR2(9)
  (state, 1, 'READY', 2, 'STARTED', 3, 'ACTIVE', 4, 'DISCARDED', 5, 'DETACHED', 'UNKNOWN'),
start_scnwrp,            -- START_SCNWRP NUMBER
start_scnbas,            -- START_SCNBAS NUMBER
end_scnwrp,              -- END_SCNWRP NUMBER
end_scnbas,              -- END_SCNBAS NUMBER
spill_scnwrp,            -- SPILL_SCNWRP NUMBER
spill_scnbas,            -- SPILL_SCNBAS NUMBER
required_slave_num,      -- REQUIRED_SLAVE_NUM NUMBER
eager_threshold,         -- EAGER_THRESHOLD NUMBER
stopmining_threshold,    -- STOPMINING_THRESHOLD NUMBER
memory_size,             -- MEMORY_SIZE NUMBER
client_id,               -- CLIENT_ID NUMBER
db_id,                   -- DB_ID NUMBER
reset_scnwrp,            -- RESET_SCNWRP NUMBER
reset_scnbas,            -- RESET_SCNBAS NUMBER
callback_count,          -- CALLBACK_COUNT NUMBER
slave_count              -- SLAVE_COUNT NUMBER
from
x$logmnr_session
home |  up  |  mailbox