ALL_QUEUES v16

The ALL_QUEUES view provides information about any currently defined queues.

NameTypeDescription
ownerTEXTUser name of the queue owner.
nameTEXTName of the queue.
queue_tableTEXTName of the queue table in which the queue resides.
qidOIDThe system-assigned object ID of the queue.
queue_typeCHARACTER VARYINGThe queue type. Can be EXCEPTION_QUEUE, NON_PERSISTENT_QUEUE, or NORMAL_QUEUE.
max_retriesNUMERICThe maximum number of dequeue attempts.
retrydelayNUMERICThe maximum time allowed between retries.
enqueue_enabledCHARACTER VARYINGYES if the queue allows enqueuing, NO if the queue does not.
dequeue_enabledCHARACTER VARYINGYES if the queue allows dequeuing, NO if the queue does not.
retentionCHARACTER VARYINGThe number of seconds that a processed message is retained in the queue.
user_commentCHARACTER VARYINGUser-specified comment.
network_nameCHARACTER VARYINGName of the network on which the queue resides.
shardedCHARACTER VARYINGYES if the queue resides on a sharded network, NO if the queue does not.