[Home] [Help] [Dependency Information]
Object Name: | DBA_QUEUE_TABLES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All queue tables created in the database
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 |
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;
|
|
|