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

Related:

DBA_QUEUE_TABLES
DBA_QUEUE_PUBLISHERS
DBA_QUEUE_SUBSCRIBERS
DBA_QUEUE_SCHEDULES
DBA_ATTRIBUTE_TRANSFORMATIONS


© Copyright SS64.com 1999-2014
Some rights reserved