GV$LOGMNR_PROCESS

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(22)
a.overhead_microsec,     -- OVERHEAD_MICROSEC VARCHAR2(22)
b.spid,                  -- SPID VARCHAR2(12)
b.username,              -- USERNAME VARCHAR2(15)
b.latchwait,             -- LATCHWAIT VARCHAR2(8)
b.latchspin,             -- LATCHSPIN VARCHAR2(8)
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
home |  up  |  mailbox