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

VIEW: SYS.DBA_QUEUE_TABLES

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

All queue tables created in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Owner of the queue table
QUEUE_TABLE VARCHAR2 (128)
Name of the queue table
TYPE VARCHAR2 (7)
Name of the payload type
OBJECT_TYPE VARCHAR2 (257)
Name of the payload type for object type payload
SORT_ORDER VARCHAR2 (22)
Sort order for the queue table
RECIPIENTS VARCHAR2 (8)
Mulitple or single recipient queue
MESSAGE_GROUPING VARCHAR2 (13)
Transaction grouping
COMPATIBLE VARCHAR2 (6)
Compatibility version of the queue table
PRIMARY_INSTANCE NUMBER

Instance assigned as the primary owner of the queue table
SECONDARY_INSTANCE NUMBER

Instance assigned as the secondary owner of the queue table
OWNER_INSTANCE NUMBER

Instance which owns the queue table currently
USER_COMMENT VARCHAR2 (50)
User specified comment
SECURE VARCHAR2 (3)
Secure queue table
Query Text

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


SELECT OWNER
,      QUEUE_TABLE
,      TYPE
,      OBJECT_TYPE
,      SORT_ORDER
,      RECIPIENTS
,      MESSAGE_GROUPING
,      COMPATIBLE
,      PRIMARY_INSTANCE
,      SECONDARY_INSTANCE
,      OWNER_INSTANCE
,      USER_COMMENT
,      SECURE
FROM SYS.DBA_QUEUE_TABLES;

Dependencies

[top of page]

SYS.DBA_QUEUE_TABLES references the following:

SchemaSYS
TableAQ$_QUEUE_TABLE_AFFINITIES
TableCOL$
TableCOLTYPE$
TableOBJ$
TableUSER$
SchemaSYSTEM
TableAQ$_QUEUE_TABLES
SYS.DBA_QUEUE_TABLES is referenced by following:

SchemaPUBLIC
SynonymDBA_QUEUE_TABLES
SchemaSYS
ViewDBA_XSTREAM_OUT_SUPPORT_MODE
Package BodyDBMS_AQADM_SYS - 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
ViewSTRADDLING_TS_OBJECTS