Selecting Queues In User Schema

Figure 10-10 Use Case Diagram: Selecting Queues in User Schema

Text description of the illustration adq10qvw15.gif

Name of View

USER_QUEUES

Purpose

This view is the same as DBA_QUEUES with the exception that it only shows queues in the user's schema.

Table 10-10 USER_QUEUES

Column Name & Description	Null?	Type
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)