select
  inst_id,                                 -- INST_ID NUMBER
  queue_id,                                -- QUEUE_ID NUMBER
  queue_schema,                            -- QUEUE_SCHEMA VARCHAR2(30)
  queue_name,                              -- QUEUE_NAME VARCHAR2(30)
  sender_name,                             -- SENDER_NAME VARCHAR2(30)
  sender_address,                          -- SENDER_ADDRESS VARCHAR2(1024)
  sender_protocol,                         -- SENDER_PROTOCOL NUMBER
  num_msgs,                                -- NUM_MSGS NUMBER
  cnum_msgs,                               -- CNUM_MSGS NUMBER
  last_enqueued_msg,                       -- LAST_ENQUEUED_MSG NUMBER
  unbrowsed_msgs,                          -- UNBROWSED_MSGS NUMBER
  overspilled_msgs,                        -- OVERSPILLED_MSGS NUMBER
  memory_usage,                            -- MEMORY_USAGE NUMBER
  elapsed_enqueue_time/10000,              -- ELAPSED_ENQUEUE_TIME NUMBER
  enqueue_cpu_time/10000,                  -- ENQUEUE_CPU_TIME NUMBER
  last_enqueue_time,                       -- LAST_ENQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE
  decode(                                  -- PUBLISHER_STATE VARCHAR2(59)
    bitand(publisher_flags, 7), 1, 'IN FLOW CONTROL: TOO MANY UNBROWSED MESSAGES', 2, 'IN FLOW CONTROL: OVERSPILLED MESSAGES', 4, 'IN FLOW CONTROL: INSUFFICIENT MEMORY AND UNBROWSED MESSAGES', 0, 'PUBLISHING MESSAGES') 
from
  x$buffered_publishers