DBA_QUEUES

All database queues
Columns
   ___________________________
 
   OWNER
      Owner of the queue
   NAME
      Name of the queue
   QUEUE_TABLE
      Name of the table the queue data resides in
   QID
      Object number of the queue
   QUEUE_TYPE
      Type of the queue
   MAX_RETRIES
      Maximum number of retries allowed when dequeuing from the queue
   RETRY_DELAY
      Time interval between retries
   ENQUEUE_ENABLED
      Queue is enabled for enqueue
   DEQUEUE_ENABLED
      Queue is enabled for dequeue
   RETENTION
      Time interval processed messages retained in the queue
   USER_COMMENT
      User specified comment