GV$REPLPROP definition in Oracle Database 10.2 / www.oracledba.ru
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)