GoldenGate関連プロセスのsession情報を確認する方法

SELECT
    s.inst_id,
    s.con_id,
    s.logon_time,
    s.sid,
    s.serial#,
    s.module,
    p.spid,
    p.pid,
    s.action,
    s.process,
    s.program,
    s.status,
    s.action,
    DECODE(s.server,'DEDICATED','DED','SHR') SVR,
    s.STATE,
    s.event
FROM
    gv$session s,
    v$process p
WHERE
    (s.module = 'GoldenGate' OR
        s.module LIKE '%tream%' OR
        s.module LIKE 'OGG%') AND
    p.addr=s.paddr
ORDER BY
    s.con_id,
    s.inst_id,
    s.module,
    s.action;