DBA_QUEUES
All database queues
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the queue |
NAME | VARCHAR2 | (30) | Yes | Name of the queue |
QUEUE_TABLE | VARCHAR2 | (30) | Yes | Name of the table the queue data resides in |
QID | NUMBER | Yes | Object number of the queue | |
QUEUE_TYPE | VARCHAR2 | (20) | Type of the queue | |
MAX_RETRIES | NUMBER | Maximum number of retries allowed when dequeuing from the queue | ||
RETRY_DELAY | NUMBER | Time interval between retries | ||
ENQUEUE_ENABLED | VARCHAR2 | (7) | Queue is enabled for enqueue | |
DEQUEUE_ENABLED | VARCHAR2 | (7) | Queue is enabled for dequeue | |
RETENTION | VARCHAR2 | (40) | Time interval processed messages retained in the queue | |
USER_COMMENT | VARCHAR2 | (50) | User specified comment |
Usage:
cursor cur_queue(c_name in dba_objects.object_name%type
, c_owner in dba_objects.owner%type) is
SELECT QUEUE_TABLE
, QUEUE_TYPE
, MAX_RETRIES
, RETRY_DELAY
, ENQUEUE_ENABLED
, DEQUEUE_ENABLED
, RETENTION
, USER_COMMENT
FROM SYS.DBA_QUEUES
where OWNER = c_owner
and NAME = c_name;