Administrative Interface: Views, 7 of 16

Oracle8i Application Developer's Guide - Advanced Queuing
Release 2 (8.1.6)
Part Number A76938-01

Administrative Interface: Views, 7 of 16

Select Queues for Which User Has Any Privilege

Figure 10-6 Use Case Diagram: Select Queues for which User has Any Privilege

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:

ALL_QUEUES

Purpose:

This view describes all queues accessible to the user.

Table 10-6 ALL_QUEUES

Column Name & Description	Null?	Type
`OWNER -- Owner of the queue`	`NOT NULL`	`VARCHAR2(30)`
`NAME -- Name of the queue`	`NOT NULL`	`VARCHAR2(30)`
`QUEUE_TABLE -- Name of the table the queue data resides in`	`NOT NULL`	`VARCHAR2(30)`
`QID -- Object number of the queue`	`NOT NULL`	`NUMBER`
`QUEUE_TYPE -- Type of the queue`		`VARCHAR2(15)`
`MAX_RETRIES -- Maximum number of retries allowed when dequeuing from the queue`		`NUMBER`
`RETRY_DELAY -- Time interval between retries`		`NUMBER`
`ENQUEUE_ENABLED -- Queue is enabled for enqueue`		`VARCHAR2(7)`
`DEQUEUE_ENABLED -- Queue is enabled for dequeue`		`VARCHAR2(7)`
`RETENTION -- Time interval processed messages retained in the queue`		`VARCHAR2(40)`
`USER_COMMENT -- User specified comment`		`VARCHAR2(50)`

Oracle

Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.