Administrative Interface: Views, 11 of 16

Select Queues In User Schema

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

"Use Case Model: Administrative Interface -- Views"

USER_QUEUES

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

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