Oracle8i Application Developer's Guide - Advanced Queuing Release 8.1.5 A68005-01 |
|
In this chapter we describe the administrative interface with respect to views in terms of a hybrid of use cases and state diagrams. That is, we describe each view as a use case in terms of the operations that represents it (such as "Select All Queue Tables in Database"). We describe each view as a state diagram in that each attribute of the view is represented as a possible state of the view, the implication being that any attribute (column) can be visible or invisible.
The table listing all the use cases is provided at the head of the chapter (see "Use Case Model: Administrative Interface -- Views"). A summary figure, "Use Case Diagram: Administrator's Interface -- Views", locates all the use cases in single drawing. If you are using the HTML version of this document, you can use this figure to navigate to the use case in which you are interested by clicking on the relevant use case title.
The individual use cases are themselves laid out as follows:
Use Case | Name of View |
---|---|
DBA_QUEUE_TABLES |
|
ALL_QUEUE_TABLES |
|
DBA_QUEUES |
|
DBA_QUEUE_SCHEDULES |
|
ALL_QUEUES |
|
QUEUE_PRIVILEGES |
|
AQ$<name of queue table> |
|
USER_QUEUE_TABLES |
|
USER_QUEUES |
|
USER_QUEUE_SCHEDULES |
|
AQ$<name of queue table>_S |
|
AQ$<name of queue table>_R |
|
Select the Number of Messages in Different States for the Whole Database |
GV$AQ |
Select the Number of Messages in Different States for Specific Instances |
VSAQ |
DBA_QUEUE_TABLES
This view describes the names and types of all queue tables created in the database.
ALL_QUEUE_TABLES
This view describes queue tables accessible to a user.
DBA_QUEUES
Users can specify operational characteristics for individual queues. DBA_QUEUES
contains the view which contains relevant information for every queue in a database.
DBA_QUEUE_SCHEDULES
This view describes the current schedules for propagating messages.
ALL_QUEUES
This view describes all queues accessible to the user.
QUEUE_PRIVILEGES
This view describes queues for which the user is the grantor, or grantee, or owner, or an enabled role or the queue is granted to PUBLIC
.
AQ$<name of queue table>
This view describes the queue table in which message data is stored. This view is automatically created with each queue table and should be used for querying the queue data. The dequeue history data (time, user identification and transaction identification) is only valid for single consumer queues.
USER_QUEUE_TABLES
This view is the same as DBA_QUEUE_TABLES
with the exception that it only shows queue tables in the user's schema. It does not contain a column for OWNER
.
USER_QUEUES
This view is the same as DBA_QUEUES
with the exception that it only shows queues in the user's schema.
USER_QUEUE_SCHEDULES
Purpose:
AQ$<queue_table_name>_S
This is a view of all the subscribers for all the queues in any given queue table. This view is generated when the queue table is created and is called aq$<queue_table_name>_s
.This view is used to query subscribers for any or all the queues in this queue table. Note that this view is only created for 8.1-compatible queue tables.
For queues created in 8.1-compatible queue tables, this view provides functionality that is equivalent to the dbms_aqadm.queue_subscribers() procedure. For these queues, it is recommended that the view be used instead of this procedure to view queue subscribers.
AQ$<queue_table_name>_R
This view displays only the rule based subscribers for all queues in a given queue table including the text of the rule defined by each subscriber. This is a view of subscribers with rules defined on any queues of a given queue table. This view is generated when the queue table is created and is called aq$<queue_table_name>_r. It is used to query subscribers for any or all the queues in this queue table. Note that this view is only created for 8.1-compatible queue tables.
GV$AQ
Provides information about the number of messages in different states for the whole database.
V$AQ
Provides information about the number of messages in different states for specific instances.