Using
add_table_propagation_rules
There is another useful SQL query that can
be used to view the propagation details including the bytes
transferred etc. v$propagation_sender displays
information about buffer queue propagation schedules on the
source side. Columns such as TOTAL_MSGS, TOTAL_BYTES, and
HIGH_WATER_MARK are helpful in showing the progress and load on
the Propagation process. The following SQL block queries the
v$propagation_sender view.
-- to see the bytes transferred etc
SELECT p.PROPAGATION_NAME,
s.QUEUE_NAME,
s.DBLINK,
s.TOTAL_MSGS,
s.TOTAL_BYTES
FROM DBA_PROPAGATION p,
V$PROPAGATION_SENDER s
SEE CODE
DEPOT FOR FULL SCRIPT
/
The above SQL statement gives the following
sample output:
Queue
Database Total Total
Propagation Name Link
Events Bytes
---------------- --------------------------
-------- --------------
NY1_PROPAGATE NY1_QUEUE DNYOIP20.WORLD
50,077 56,696,005
