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;