Use Case Model: Administrative Interface -- Views

Table 10-1 Use Case Model: Administrative Interface -- Views

Use Case	Name of View
Select All Queue Tables in Database	DBA_QUEUE_TABLES
Select User Queue Tables	ALL_QUEUE_TABLES
Select All Queues in Database	DBA_QUEUES
Select All Propagation Schedules	DBA_QUEUE_SCHEDULES
Select Queues for Which User Has Any Privilege	ALL_QUEUES
Select Queues for Which User Has Queue Privilege	QUEUE_PRIVILEGES
Select Messages in Queue Table	AQ$<name of queue table>
Select Queue Tables in User Schema	USER_QUEUE_TABLES
Select Queues In User Schema	USER_QUEUES
Select Propagation Schedules in User Schema	USER_QUEUE_SCHEDULES
Select Queue Subscribers	AQ$<name of queue table>_S
Select Queue Subscribers and Their Rules	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

Figure 10-1 Use Case Model: Administrative Interface -- Views