select
  queue_id,                                -- QUEUE_ID NUMBER
  queue_schema,                            -- QUEUE_SCHEMA VARCHAR2(30)
  queue_name,                              -- QUEUE_NAME VARCHAR2(30)
  dst_queue_schema,                        -- DST_QUEUE_SCHEMA VARCHAR2(30)
  dst_queue_name,                          -- DST_QUEUE_NAME VARCHAR2(30)
  startup_time,                            -- STARTUP_TIME DATE
  dblink,                                  -- DBLINK VARCHAR2(128)
  high_water_mark,                         -- HIGH_WATER_MARK NUMBER
  acknowledgement,                         -- ACKNOWLEDGEMENT NUMBER
  schedule_status,                         -- SCHEDULE_STATUS VARCHAR2(30)
  total_msgs,                              -- TOTAL_MSGS NUMBER
  total_bytes,                             -- TOTAL_BYTES NUMBER
  elapsed_dequeue_time,                    -- ELAPSED_DEQUEUE_TIME NUMBER
  elapsed_pickle_time,                     -- ELAPSED_PICKLE_TIME NUMBER
  elapsed_propagation_time,                -- ELAPSED_PROPAGATION_TIME NUMBER
  elapsed_rule_time,                       -- ELAPSED_RULE_TIME NUMBER
  max_num_per_win,                         -- MAX_NUM_PER_WIN NUMBER
  max_size,                                -- MAX_SIZE NUMBER
  last_msg_latency,                        -- LAST_MSG_LATENCY NUMBER
  last_msg_enqueue_time,                   -- LAST_MSG_ENQUEUE_TIME TIMESTAMP(6)
  last_msg_propagation_time,               -- LAST_MSG_PROPAGATION_TIME TIMESTAMP(6)
  last_lcr_latency,                        -- LAST_LCR_LATENCY NUMBER
  last_lcr_creation_time,                  -- LAST_LCR_CREATION_TIME DATE
  last_lcr_propagation_time,               -- LAST_LCR_PROPAGATION_TIME DATE
  dst_database_name,                       -- DST_DATABASE_NAME VARCHAR2(128)
  session_id,                              -- SESSION_ID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  spid,                                    -- SPID VARCHAR2(24)
  propagation_name,                        -- PROPAGATION_NAME VARCHAR2(30)
  state                                    -- STATE VARCHAR2(53)
from
  gv$propagation_sender
where
  inst_id = USERENV('Instance')