DBA_QUEUES v11

The DBA_QUEUES view provides information about any currently defined queues.

NameTypeDescription
ownerTEXTUser name of the queue owner.
nameTEXTThe name of the queue.
queue_tableTEXTThe name of the queue table in which the queue resides.
qidOIDThe system-assigned object ID of the queue.
queue_typeCHARACTER VARYINGThe queue type; may 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 VARYINGA user-specified comment.
network_nameCHARACTER VARYINGThe name of the network on which the queue resides.
shardedCHARACTER VARYINGYES if the queue resides on a sharded network; NO if the queue does not.