The DBA_QUEUES view provides the information about any defined queues.

Parameter Type Description
owner TEXT The username of the owner to which a queue belongs.
Parameter TEXT The name of the queue.
queue_table TEXT The name of the queue table to which the queue belongs.
qid OID The object ID of the queue. This object ID is assigned by the system.
queue_type CHARACTER VARYING The queue type. Valid values: EXCEPTION_QUEUE, NON_PERSISTENT_QUEUE, and NORMAL_QUEUE.
max_retries NUMERIC The maximum number of dequeuing attempts.
retrydelay NUMERIC The maximum time allowed between retries.
enqueue_enabled CHARACTER VARYING
  • YES: indicates that the queue allows enqueuing.
  • NO: indicates that the queue does not allow enqueuing.
dequeue_enabled CHARACTER VARYING
  • YES: indicates that the queue allows dequeuing.
  • NO: indicates that the queue does not allow dequeuing.
retention CHARACTER VARYING The number of seconds that a processed message is retained in the queue.
user_comment CHARACTER VARYING The user-defined comment.
network_name CHARACTER VARYING The name of the network in which the queue is.
sharded CHARACTER VARYING
  • YES: indicates the queue is in a sharded network.
  • NO: indicates the queue is not in a sharded network.