Skip to content

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

VIEW: SYS.CDB_QUEUES

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

All database queues in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) 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)
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_QUEUES;

Dependencies

[top of page]

SYS.CDB_QUEUES does not reference any database object

SYS.CDB_QUEUES is referenced by following:

SchemaPUBLIC
SynonymCDB_QUEUES