select
  session_id,                              -- SESSION_ID NUMBER
  pid,                                     -- PID NUMBER
  spid,                                    -- SPID VARCHAR2(24)
  role,                                    -- ROLE VARCHAR2(32)
  username,                                -- USERNAME VARCHAR2(15)
  sid,                                     -- SID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  latchwait,                               -- LATCHWAIT VARCHAR2(16)
  latchspin,                               -- LATCHSPIN VARCHAR2(16)
  work_microsec,                           -- WORK_MICROSEC VARCHAR2(21)
  overhead_microsec                        -- OVERHEAD_MICROSEC VARCHAR2(21)
from
  gv$logmnr_process
where
  inst_id = userenv('instance')