GV$LOGMNR_PROCESS

select
a.inst_id,               -- INST_ID NUMBER
a.pid,                   -- PID NUMBER
b.spid,                  -- SPID VARCHAR2(12)
a.role,                  -- ROLE VARCHAR2(32)
b.username,              -- USERNAME VARCHAR2(15)
b.serial#,               -- SERIAL# NUMBER
b.latchwait,             -- LATCHWAIT VARCHAR2(8)
b.latchspin              -- LATCHSPIN VARCHAR2(8)
from
x$logmnr_process a,
v$process b 
where
a.pid = b.pid
home |  up  |  mailbox