DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_QUEUES

Object Details
Object Name: DBA_QUEUES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All database queues

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the queue
NAME VARCHAR2 (128) Yes Name of the queue
QUEUE_TABLE VARCHAR2 (128) 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
NETWORK_NAME VARCHAR2 (512)
Network name of queue service
SHARDED VARCHAR2 (5)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      NAME
,      QUEUE_TABLE
,      QID
,      QUEUE_TYPE
,      MAX_RETRIES
,      RETRY_DELAY
,      ENQUEUE_ENABLED
,      DEQUEUE_ENABLED
,      RETENTION
,      USER_COMMENT
,      NETWORK_NAME
,      SHARDED
FROM SYS.DBA_QUEUES;

Dependencies

[top of page]

SYS.DBA_QUEUES references the following:

SchemaSYS
ViewDBA_SERVICES
TableUSER$
SchemaSYSTEM
TableAQ$_QUEUES
TableAQ$_QUEUE_TABLES
SYS.DBA_QUEUES is referenced by following:

SchemaAPPS
Package BodyETRM_PNAV - show dependent code
SchemaPUBLIC
SynonymDBA_QUEUES
SchemaSYS
Package BodyDBMS_AQADM_SYS - show dependent code
Package BodyDBMS_AQJMS - show dependent code
Package BodyDBMS_AQJMS_INTERNAL - show dependent code
Package BodyDBMS_LOGREP_EXP - show dependent code
Package BodyDBMS_LOGREP_UTIL - show dependent code
Package BodyDBMS_STREAMS_ADM_UTL - show dependent code
Package BodyDBMS_STREAMS_SM - show dependent code
Package BodyKUPC$QUE_INT - show dependent code