select
  src_queue_schema,                        -- SRC_QUEUE_SCHEMA VARCHAR2(30)
  src_queue_name,                          -- SRC_QUEUE_NAME VARCHAR2(30)
  src_dbname,                              -- SRC_DBNAME VARCHAR2(128)
  dst_queue_schema,                        -- DST_QUEUE_SCHEMA VARCHAR2(30)
  dst_queue_name,                          -- DST_QUEUE_NAME VARCHAR2(30)
  startup_time,                            -- STARTUP_TIME DATE
  high_water_mark,                         -- HIGH_WATER_MARK NUMBER
  acknowledgement,                         -- ACKNOWLEDGEMENT NUMBER
  last_received_msg,                       -- LAST_RECEIVED_MSG NUMBER
  total_msgs,                              -- TOTAL_MSGS NUMBER
  elapsed_unpickle_time,                   -- ELAPSED_UNPICKLE_TIME NUMBER
  elapsed_rule_time,                       -- ELAPSED_RULE_TIME NUMBER
  elapsed_enqueue_time,                    -- ELAPSED_ENQUEUE_TIME NUMBER
  session_id,                              -- SESSION_ID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  spid,                                    -- SPID VARCHAR2(24)
  propagation_name,                        -- PROPAGATION_NAME VARCHAR2(30)
  state,                                   -- STATE VARCHAR2(43)
  acknowledgement_position,                -- LAST_RECEIVED_MSG_POSITION RAW(64)
  last_received_msg_position               -- ACKNOWLEGEMENT_POSITION RAW(64)
from
  gv$propagation_receiver
where
  inst_id = USERENV('Instance')