DBA_QUEUE_SUBSCRIBERS

All queue subscribers

Columns
   ___________________________


   OWNER
      Owner of the queue
   QUEUE_NAME
      Name of the queue
   QUEUE_TABLE
      Name of the table the queue data resides in
   CONSUMER_NAME
      Name of the consumer
   ADDRESS
      
   TRANSFORMATION
      
   RULE
      
   DELIVERY_MODE
      
   IF_NONDURABLE_SUBSCRIBER
      
   QUEUE_TO_QUEUE
      
   SUBSCRIBER_ID
      
   POS_BITMAP

Related:

DBA_QUEUES