Selecting All Queues in Database

Figure 10-4 Use Case Diagram: Selecting All Queues in Database

Text description of the illustration adq10qvw7.gif

Name of View

DBA_QUEUES

Purpose

Users can specify operational characteristics for individual queues. DBA_QUEUES contains the view which contains relevant information for every queue in a database.

Table 10-4  DBA_QUEUES

Column Name & Description	Null?	Type
OWNER--queue schema name	NOT NULL	VARCHAR2(30)
NAME--queue name	NOT NULL	VARCHAR2(30)
QUEUE_TABLE--queue table where this queue resides	NOT NULL	VARCHAR2(30)
QID--unique queue identifier	NOT NULL	NUMBER
QUEUE_TYPE--queue type		VARCHAR2(15)
MAX_RETRIES--number of dequeue attempts allowed		NUMBER
RETRY_DELAY--number of seconds before retry can be attempted		NUMBER
ENQUEUE_ENABLED--YES/NO		VARCHAR2(7)
DEQUEUE_ENABLED--YES/NO		VARCHAR2(7)
RETENTION--number of seconds message is retained after dequeue		VARCHAR2(40)
USER_COMMENT--user comment for the queue		VARCHAR2(50)