select
  a.inst_id,                               -- INST_ID NUMBER
  a.session_id,                            -- SESSION_ID NUMBER
  a.pid,                                   -- PID NUMBER
  a.role,                                  -- ROLE VARCHAR2(32)
  a.work_microsec,                         -- WORK_MICROSEC VARCHAR2(21)
  a.overhead_microsec,                     -- OVERHEAD_MICROSEC VARCHAR2(21)
  b.spid,                                  -- SPID VARCHAR2(24)
  b.username,                              -- USERNAME VARCHAR2(15)
  b.latchwait,                             -- LATCHWAIT VARCHAR2(16)
  b.latchspin,                             -- LATCHSPIN VARCHAR2(16)
  c.sid,                                   -- SID NUMBER
  c.serial#                                -- SERIAL# NUMBER
from
  x$logmnr_process a,
  v$process b,
  v$session c
where
  a.pid = b.pid and b.spid = c.process