Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_QUEUES
describes all queues on which the current user has enqueue or dequeue privileges. If the user has any Advanced Queuing system privileges, like MANAGE ANY QUEUE
, ENQUEUE ANY QUEUE
or DEQUEUE ANY QUEUE
, then this view describes all queues in the database.
DBA_QUEUES
describes all queues in the database.
USER_QUEUES
describes the operational characteristics of every queue owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the queue |
NAME |
VARCHAR2(30) |
NOT NULL |
Name of the queue |
QUEUE_TABLE |
VARCHAR2(30) |
NOT NULL |
Name of the table the queue data resides in |
QID |
NUMBER |
NOT NULL |
Object number of the queue |
QUEUE_TYPE |
VARCHAR2(15) |
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 |
See Also: Oracle Streams Advanced Queuing User's Guide and Reference for more information about these views and Advanced Queuing |