Selecting All Queue Tables in Database

Figure 10-2 Use Case Diagram: Select All Queue Tables in Database

Text description of the illustration adq10qvw5.gif

Name of View

DBA_QUEUE_TABLES

Purpose

This view describes the names and types of all queue tables created in the database.

Table 10-2 DBA_QUEUE_TABLES

Column Name & Description	Null?	Type
OWNER--queue table schema		VARCHAR2(30)
QUEUE_TABLE--queue table name		VARCHAR2(30)
TYPE--payload type		VARCHAR2(7)
OBJECT_TYPE--name of object type, if any		VARCHAR2(61)
SORT_ORDER--user specified sort order		VARCHAR2(22)
RECIPIENTS--SINGLE or MULTIPLE		VARCHAR2(8)
MESSAGE_GROUPING--NONE or TRANSACTIONAL		VARCHAR2(13)
COMPATIBLE--indicates the lowest version with which the queue table is compatible		VARCHAR2(5)
PRIMARY_INSTANCE--indicates which instance is the primary owner of the queue table; a value of 0 indicates that there is no primary owner		NUMBER
SECONDARY_INSTANCE--indicates which owner is the secondary owner of the queue table; this instance becomes the owner of the queue table if the primary owner is not up; a value of 0 indicates that there is no secondary owner		NUMBER
OWNER_INSTANCE--indicates which instance currently owns the queue table		NUMBER
USER_COMMENT--user comment for the queue table		VARCHAR2(50)