VIEW: SYS.DBA_QUEUES

Source

View Text - Preformatted

select u.name OWNER, q.name NAME, t.name QUEUE_TABLE, q.eventid QID,
       decode(q.usage, 1, 'EXCEPTION_QUEUE', 2, 'NON_PERSISTENT_QUEUE',
              'NORMAL_QUEUE') QUEUE_TYPE,
       q.max_retries MAX_RETRIES, q.retry_delay RETRY_DELAY,
       decode(bitand(q.enable_flag, 1), 1 , '  YES  ', '  NO  ')ENQUEUE_ENABLED,
       decode(bitand(q.enable_flag, 2), 2 , '  YES  ', '  NO  ')DEQUEUE_ENABLED,
       decode(q.ret_time, -1, ' FOREVER', q.ret_time) RETENTION,
       substr(q.queue_comment, 1, 50) USER_COMMENT,
       s.network_name NETWORK_NAME,
       decode(q.sharded, 1, 'TRUE', 'FALSE') SHARDED
from system.aq$_queues q, system.aq$_queue_tables t, sys.user$ u,
dba_services s
where u.name  = t.schema
and   q.table_objno = t.objno
and   q.service_name = s.name (+)

View Text - HTML Formatted

SELECT U.NAME OWNER
, Q.NAME NAME
, T.NAME QUEUE_TABLE
, Q.EVENTID QID
, DECODE(Q.USAGE
, 1
, 'EXCEPTION_QUEUE'
, 2
, 'NON_PERSISTENT_QUEUE'
, 'NORMAL_QUEUE') QUEUE_TYPE
, Q.MAX_RETRIES MAX_RETRIES
, Q.RETRY_DELAY RETRY_DELAY
, DECODE(BITAND(Q.ENABLE_FLAG
, 1)
, 1
, ' YES '
, ' NO ')ENQUEUE_ENABLED
, DECODE(BITAND(Q.ENABLE_FLAG
, 2)
, 2
, ' YES '
, ' NO ')DEQUEUE_ENABLED
, DECODE(Q.RET_TIME
, -1
, ' FOREVER'
, Q.RET_TIME) RETENTION
, SUBSTR(Q.QUEUE_COMMENT
, 1
, 50) USER_COMMENT
, S.NETWORK_NAME NETWORK_NAME
, DECODE(Q.SHARDED
, 1
, 'TRUE'
, 'FALSE') SHARDED FROM SYSTEM.AQ$_QUEUES Q
, SYSTEM.AQ$_QUEUE_TABLES T
, SYS.USER$ U
, DBA_SERVICES S WHERE U.NAME = T.SCHEMA AND Q.TABLE_OBJNO = T.OBJNO AND Q.SERVICE_NAME = S.NAME (+)