Administrative Interface: Views, 5 of 16

Select All Queues in Database

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

To refer to the table of all basic operations having to do with the Operational Interface see:

"Use Case Model: Administrative Interface -- Views"

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)`