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

VIEW: SYS.ALL_QUEUES

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

All queues accessible to the user

[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.ALL_QUEUES;

Dependencies

[top of page]

SYS.ALL_QUEUES references the following:

SchemaSYS
ViewDBA_SERVICES
TableOBJ$
TableOBJAUTH$
TableUSER$
SchemaSYSTEM
TableAQ$_QUEUES
TableAQ$_QUEUE_TABLES
SYS.ALL_QUEUES is referenced by following:

SchemaPUBLIC
SynonymALL_QUEUES
SchemaSYS
ViewALL_APPLY
ViewALL_APPLY_ENQUEUE
ViewALL_APPLY_ERROR
ViewALL_CAPTURE
ViewALL_PROPAGATION
ViewALL_STREAMS_MESSAGE_CONSUMERS
ViewALL_SYNC_CAPTURE
Package BodyDBMS_AQ_EXP_QUEUE_TABLES - show dependent code
Package BodyDBMS_AQ_SYS_EXP_ACTIONS - show dependent code