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
  builder_work_size,                       -- BUILDER_WORK_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