DBA_QUEUES v16

The DBA_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.
qidOIDSystem-assigned object ID of the queue.
queue_typeCHARACTER VARYINGQueue type. Possible values are EXCEPTION_QUEUE, NON_PERSISTENT_QUEUE, or NORMAL_QUEUE.
max_retriesNUMERICMaximum number of dequeue attempts.
retrydelayNUMERICMaximum 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 VARYINGNumber 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.