Oracle8i Application Developer's Guide - Advanced Queuing
Release 2 (8.1.6)

Part Number A76938-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Administrative Interface: Views, 2 of 16


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



Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index