GV$REPLPROP

select
inst_id,                 -- INST_ID NUMBER
sid_knst,                -- SID NUMBER
serial_knst,             -- SERIAL# NUMBER
decode                   -- NAME VARCHAR2(71)
  (type_knst, 3, 'Replication Parallel Prop Slave'|| slavenum_knstrpp, 4, 'Replication Parallel Prop Coordinator'),
dblink_knstrpp,          -- DBLINK VARCHAR2(128)
decode                   -- STATE VARCHAR2(12)
  (state_knstrpp, 0, NULL, 1, 'WAIT', 2, 'SLEEP', 3, 'PUSH', 4, 'PURGE', 5, 'CREATE ERROR', 6, 'SCHEDULE TXN'),
decode                   -- XID VARCHAR2(22)
  (type_knst, 4, NULL, xid_knstrpp),
sequence_knstrpp         -- SEQUENCE NUMBER
from
x$knstrpp x 
where
type_knst in (3,
4) and exists (
select
1 
from
v$session s 
where
s.sid=x.sid_knst and s.serial#=x.serial_knst)
home |  up  |  mailbox