Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_QUEUES

All queues owned by the user

Columns
   ___________________________
 
   USER_COMMENT
      User specified comment
   QID
      Object number of the queue
   QUEUE_TYPE
      Type of the queue
   NAME
      Name 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
   QUEUE_TABLE
      Name of the table the queue data resides in

Related Commands:




Back to the Top

Simon Sheppard
SS64.com