DBA_QUEUES

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

Related Commands: