SELECT p.PROPAGATION_NAME, s.TOTAL_TIME, s.TOTAL_NUMBER, s.TOTAL_BYTES
  FROM DBA_QUEUE_SCHEDULES s, DBA_PROPAGATION p
  WHERE p.DESTINATION_DBLINK = s.DESTINATION
    AND s.SCHEMA = p.SOURCE_QUEUE_OWNER
    AND s.QNAME = p.SOURSQL> SQL> CE_QUEUE_NAME;SQL> SQL> SQL>   2    3    4    5

                     Total Time
Propagation           Executing Total Messages    Total Bytes
Name                 in Seconds     Propagated     Propagated
-------------------- ---------- -------------- --------------
PROP_SFDB_TO_LADB           159             83          69235
PROP_SFDB_TO_LADB             0              0              0

SQL> SELECT APPLY_NAME,
      TOTAL_RECEIVED,
      TOTAL_APPLIED,
      TOTAL_ERRORS,
      (TOTAL_ASSIGNED - (TOTAL_ROLLBACKS + TOTAL_APPLIED)) BEING_APPLIED,
      TOTAL_IGNORED
      FROM V$STREAMS_APPLY_COORDINATOR;  2    3    4    5    6    7

Apply          Total     Total  Total       Total     Total
Process        Trans     Trans  Apply Trans Being     Trans
Name        Received   Applied Errors     Applied   Ignored
---------- --------- --------- ------ ----------- ---------
APPLY_SRC_         0         0      0           0         0
SFDB

COLUMN apply_name              FORMAT A20             HEADING 'Apply'
COLUMN process_name            FORMAT A07             HEADING 'Process'
COLUMN sid                     FORMAT A08             HEADING 'Sid'
COLUMN state                   FORMAT A17             HEADING 'State'
COLUMN total_messages_dequeued FORMAT 99G999G999G999  HEADING 'Nb Msg dequeued'
COLUMN total_applied           FORMAT 999G999G999G999 HEADING 'Total TX Applied' 
SELECT r.apply_name, substr(s.program, instr(s.program,'(')+1,4) process_name, 
       r.sid||','||r.serial# sid, r.state, 
       r.total_messages_dequeued, c.total_applied 
FROM v$streams_apply_reader r,  v$streams_apply_coordinator c,  
     v$session s, dba_apply ap 
WHERE r.sid = s.sid 
  AND r.serial# = s.serial# 
  AND r.apply_name = ap.apply_name 
  AND r.apply_name = c.apply_name 
ORDER BY 1
/

SQL> COLUMN apply_name              FORMAT A20             HEADING 'Apply'
COLUMN process_name            FORMAT A07             HEADING 'Process'
COLUMN sid                     FORMAT A08             HEADING 'Sid'
COLUMN state                   FORMAT A17             HEADING 'State'
COLUMN total_messages_dequeued FORMAT 99G999G999G999  HEADING 'Nb Msg dequeued'
COLUMN total_applied           FORMAT 999G999G999G999 HEADING 'Total TX Applied'
SELECT r.apply_name, substr(s.program, instr(s.program,'(')+1,4) process_name,
       r.sid||','||r.serial# sid, r.state,
       r.total_messages_dequeued, c.total_applied
FROM v$streams_apply_reader r,  v$streams_apply_coordinator c,
     v$session s, dba_apply ap
WHERE r.sid = s.sid
  AND r.serial# = s.serial#
  AND r.apply_name = ap.apply_name
  AND r.apply_name = c.apply_name
ORDER BY 1
/SQL> SQL> SQL> SQL> SQL> SQL>   2    3    4    5    6    7    8    9   10   11

Apply                Process Sid      State             Nb Msg dequeued
-------------------- ------- -------- ----------------- ---------------
Total TX Applied
----------------
APPLY_SRC_SFDB       P000    128,424  DEQUEUE MESSAGES                0
               0

SQL> select state from v$session_wait where sid=128;

State
-----------------
WAITING

SQL> select p1,p2,p3,wait_class,state,SECONDS_IN_WAIT,event,event# from v$session where sid=128;

        P1         P2         P3
---------- ---------- ----------
WAIT_CLASS
----------------------------------------------------------------
State             SECONDS_IN_WAIT
----------------- ---------------
EVENT                                                                EVENT#
---------------------------------------------------------------- ----------
     51405 1.5253E+10          3
Idle
WAITING                     40764
Streams AQ: waiting for messages in the queue                           266

But please see ,In this example source as treated as destination and dest is treated as source

SQL> select * from global_name
  2  ;

GLOBAL_NAME
--------------------------------------------------------------------------------
DEST.WORLD

SELECT p.PROPAGATION_NAME,
       p.SOURCE_QUEUE_OWNER,
       p.SOURCE_QUEUE_NAME ||'@'||
       g.GLOBAL_NAME "Source Queue",
       p.DESTINATION_QUEUE_OWNER,
       p.DESTINATION_QUEUE_SQL> SQL> SQL> NAME ||'@'||
       p.DESTINATION_DBLINK "Destination Queue"
  FROM DBA_PROPAGATION p, GLOBAL_NAME g;SQL> SQL> SQL>   2    3    4    5    6    7    8

                     Source                     Dest
Propagation          Queue      Source          Queue      Destination
Name                 Owner      Queue           Owner      Queue
-------------------- ---------- --------------- ---------- ---------------
PROP_SFDB_TO_LADB    STRMADMIN  CAPTURE_SFQ@DES STRMADMIN  APPLY_LAQ@SOURC
                                T.WORLD                    E.WORLD





SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SOURCE.WORLD

SQL> select queue_name, queue_owner, apply_user from dba_apply;

Queue           Queue
Name            Owner APPLY_USER
--------------- ----- ------------------------------
APPLY_LAQ       STRMA STRMADMIN
                DMIN

SQL> !hostname
terminus

SQL> show parameter global_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     TRUE
SQL> select instance from v$thread;

INSTANCE
--------------------------------------------------------------------------------
source

SQL>  !hostname
saturn

SQL> show parameter global_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     TRUE
SQL> select instance from v$thread;

INSTANCE
--------------------------------------------------------------------------------
dest