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'),
db_name,                 -- DB_NAME VARCHAR2(128)
db_id,                   -- DB_ID NUMBER
reset_scn,               -- RESET_SCN NUMBER
reset_timestamp,         -- RESET_TIMESTAMP NUMBER
num_process,             -- NUM_PROCESS NUMBER
chunk_size,              -- CHUNK_SIZE NUMBER
start_scn,               -- START_SCN NUMBER
end_scn,                 -- END_SCN NUMBER
spill_scn,               -- SPILL_SCN NUMBER
processed_scn,           -- PROCESSED_SCN NUMBER
prepared_scn,            -- PREPARED_SCN NUMBER
read_scn,                -- READ_SCN NUMBER
low_mark_scn,            -- LOW_MARK_SCN NUMBER
consumed_scn,            -- CONSUMED_SCN NUMBER
max_memory_size,         -- MAX_MEMORY_SIZE NUMBER
used_memory_size,        -- USED_MEMORY_SIZE NUMBER
prepared_work_size,      -- PREPARED_WORK_SIZE NUMBER
available_work_size,     -- AVAILABLE_WORK_SIZE NUMBER
available_txn,           -- AVAILABLE_TXN NUMBER
available_committed_txn, -- AVAILABLE_COMMITTED_TXN NUMBER
delivered_txn,           -- DELIVERED_TXN NUMBER
delivered_committed_txn, -- DELIVERED_COMMITTED_TXN NUMBER
pinned_txn,              -- PINNED_TXN NUMBER
pinned_committed_txn,    -- PINNED_COMMITTED_TXN NUMBER
checkpoint_interval      -- CHECKPOINT_INTERVAL NUMBER
from
x$logmnr_session
home |  up  |  mailbox