Oracle8i Application Developer's Guide - Advanced Queuing
Release 8.1.5

A68005-01

Library

Product

Contents

Index

Prev Next

5
Administrative Interface: Views

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 Model: Administrative Interface -- Views

Table 5-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 5-1 Use Case Model: Administrative Interface -- Views


SELECT all queue tables in database SELECT all queues in database SELECT all propagation schedules SELECT queues for which user has any privilege SELECT queues for which user has queue privilege SELECT messages in queue table SELECT queue tables in user schema SELECT queues in user schema SELECT prop schedules in user schema SELECT queue subscribers SELECT queue subscribers and their rules

Select All Queue Tables in Database

Figure 5-2 Use Case Diagram: Select All Queue Tables in Database



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

 

Name of View:

DBA_QUEUE_TABLES

Purpose:

This view describes the names and types of all queue tables created in the database.

Table 5-2 DBA_QUEUE_TABLES
Column Name & Description  Null?  Type  

OWNER -- queue table schema  

 

VARCHAR2(30)  

QUEUE_TABLE - queue table name  

 

VARCHAR2(30)  

TYPE -- payload type  

 

VARCHAR2(7)  

OBJECT_TYPE -- name of object type, if any  

 

VARCHAR2(61)  

SORT_ORDER -- user specified sort order  

 

VARCHAR2(22)  

RECIPIENTS -- SINGLE or MULTIPLE  

 

VARCHAR2(8)  

MESSAGE_GROUPING -- NONE or TRANSACTIONAL  

 

VARCHAR2(13)  

COMPATIBLE -- indicates the lowest version with which the queue table is compatible  

 

VARCHAR2(5)  

PRIMARY_INSTANCE -- indicates which instance is the primary owner of the queue table; a value of 0 indicates that there is no primary owner  

 

NUMBER  

SECONDARY_INSTANCE -- indicates which owner is the secondary owner of the queue table; this instance becomes the owner of the queue table if the primary owner is not up; a value of 0 indicates that there is no secondary owner  

 

NUMBER  

OWNER_INSTANCE -- indicates which instance currently owns the queue table  

 

NUMBER  

USER_COMMENT -- user comment for the queue table  

 

VARCHAR2(50)  

Select User Queue Tables

Figure 5-3 Use Case Diagram: Select User Queue Tables



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

 

Name of View:

ALL_QUEUE_TABLES

Purpose:

This view describes queue tables accessible to a user.

Table 5-3 DBA_QUEUE_TABLES
Column Name & Description  Null?  Type  

OWNER -- owner of the queue table  

 

VARCHAR2(30)  

QUEUE_TABLE - queue table name  

 

VARCHAR2(30)  

TYPE -- payload type  

 

VARCHAR2(7)  

OBJECT_TYPE -- object type, if any  

 

VARCHAR2(61)  

SORT_ORDER -- user-specified sort order  

 

VARCHAR2(22)  

RECIPIENTS -- SINGLE or MULTIPLE recipient queue  

 

VARCHAR2(8)  

MESSAGE_GROUPING -- NONE or TRANSACTIONAL  

 

VARCHAR2(13)  

COMPATIBLE -- indicates the lowest version with which the queue table is compatible  

 

VARCHAR2(5)  

PRIMARY_INSTANCE -- indicates which instance is the primary owner of the queue table; a value of 0 indicates that there is no primary owner  

 

NUMBER  

SECONDARY_INSTANCE -- indicates which owner is the secondary owner of the queue table; this instance becomes the owner of the queue table if the primary owner is not up; a value of 0 indicates that there is no secondary owner  

 

NUMBER  

OWNER_INSTANCE -- indicates which instance currently owns the queue table  

 

NUMBER  

USER_COMMENT -- user comment for the queue table  

 

VARCHAR2(50)  

Select All Queues in Database

Figure 5-4 Use Case Diagram: Select All Queues in Database



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

 

Name of View:

DBA_QUEUES

Purpose:

Users can specify operational characteristics for individual queues. DBA_QUEUES contains the view which contains relevant information for every queue in a database.

Table 5-4 DBA_QUEUES
Column Name & Description  Null?  Type  

OWNER -- queue schema name  

NOT NULL  

VARCHAR2(30)  

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)  

Select All Propagation Schedules

Figure 5-5 Use Case Diagram: Select All Propagation Schedules



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

 

Name of View:

DBA_QUEUE_SCHEDULES

Purpose:

This view describes the current schedules for propagating messages.

Table 5-5 DBA_QUEUE_SCHEDULES
Column Name & Description  Null?  Type  

SCHEMA -- schema name for the source queue  

NOT NULL  

VARCHAR2(30)  

QNAME -- source queue name  

NOT NULL  

VARCHAR2(30)  

DESTINATION -- destination name, currently limited to be a DBLINK name  

NOT NULL  

VARCHAR2(128)  

START_DATE -- date to start propagation in the default date format  

 

DATE  

START_TIME -- time of day at which to start propagation in HH:MI:SS format  

 

VARCHAR2(8)  

PROPAGATION_WINDOW -- duration in seconds for the propagation window  

 

NUMBER  

NEXT_TIME -- function to compute the start of the next propagation window  

 

VARCHAR2(200)  

LATENCY -- maximum wait time to propagate a message during the propagation window.  

 

NUMBER  

SCHEDULE_DISABLED -- N if enabled Y if disabled and schedule will not be executed  

 

VARCHAR(1)  

PROCESS_NAME -- The name of the SNP background process executing this schedule. NULL if not currently executing  

 

VARCHAR2(8)  

SESSION_ID -- The session ID (SID, SERIAL#) of the job executing this schedule. NULL if not currently executing  

 

NUMBER  

INSTANCE -- The OPS instance number executing this schedule  

 

NUMBER  

LAST_RUN_DATE -- The date on the last successful execution  

 

DATE  

LAST_RUN_TIME -- The time of the last successful execution in HH:MI:SS format  

 

VARCHAR2(8)  

CURRENT_START_DATE -- Date at which the current window of this schedule was started  

 

DATE  

CURRENT_START_TIME -- Time of day at which the current window of this schedule was started in HH:MI:SS format  

 

VARCHAR2(8)  

NEXT_RUN_DATE -- Date at which the next window of this schedule will be started  

 

DATE  

NEXT_RUN_TIME -- Time of day at which the next window of this schedule will be started in HH:MI:SS format  

 

VARCHAR2(8)  

TOTAL_TIME -- Total time in seconds spent in propagating messages from the schedule  

 

NUMBER  

TOTAL_NUMBER -- Total number of messages propagated in this schedule  

 

NUMBER  

TOTAL_BYTES -- Total number of bytes propagated in this schedule  

 

NUMBER  

MAX_NUMBER -- The maximum number of messages propagated in a propagation window  

 

NUMBER  

MAX_BYTES -- The maximum number of bytes propagated in a propagation window  

 

NUMBER  

AVG_NUMBER -- The average number of messages propagated in a propagation window  

 

NUMBER  

AVG_SIZE -- The average size of a propagated message in bytes  

 

NUMBER  

AVG_TIME -- The average time, in seconds, to propagate a message  

 

NUMBER  

FAILURES -- The number of times the execution failed. If 16, the schedule will be disabled  

 

NUMBER  

LAST_ERROR_DATE -- The date of the last unsuccessful execution  

 

DATE  

LAST_ERROR_TIME -- The time of the last unsuccessful execution  

 

VARCHAR2(8)  

LAST_ERROR_MSG -- The error number and error message text of the last unsuccessful execution  

 

VARCHAR2(4000)  


Select Queues for which User has Any Privilege

Figure 5-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:

 

Name of View:

ALL_QUEUES

Purpose:

This view describes all queues accessible to the user.

Table 5-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)  

Select Queues for which User has Queue Privilege

Figure 5-7 Use Case Diagram: Select Queues for which User has Queue Privilege



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

 

Name of View:

QUEUE_PRIVILEGES

Purpose:

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.

Table 5-7 QUEUE_PRIVILEGES
Column Name & Description  Null?  Type  

GRANTEE -- Name of the user to whom access was granted  

NOT NULL  

VARCHAR2(30)  

OWNER -- Owner of the queue  

NOT NULL  

VARCHAR2(30)  

NAME -- Name of the queue  

NOT NULL  

VARCHAR2(30)  

GRANTOR -- Name of the user who performed the grant  

NOT NULL  

VARCHAR2(30)  

ENQUEUE_PRIVILEGE -- Permission to ENQUEUE to the queue  

 

NUMBER(1 if granted, 0 if not)  

DEQUEUE_PRIVILEGE -- Permission to DEQUEUE to the queue  

 

NUMBER(1 if granted, 0 if not)  

Select Messages in Queue Table

Figure 5-8 Use Case Diagram: Select Messages in Queue Table



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

 

Name of View:

AQ$<name of queue table>

Purpose:

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.

Table 5-8 AQ$<name of queue table>
Column Name & Description  Null?  Type  

QUEUE -- queue name  

 

VARCHAR2(30)  

MSG_ID -- unique identifier of the message  

 

RAW(16)  

CORR_ID -- user-provided correlation identifier  

 

VARCHAR2(128)  

MSG_PRIORITY -- message priority  

 

NUMBER  

MSG_STATE -- state of this message  

 

VARCHAR2(9)  

DELAY -- number of seconds the message is delayed  

 

DATE  

EXPIRATION -- number of seconds in which the message will expire after being READY  

 

NUMBER  

ENQ_TIME -- enqueue time  

 

DATE  

ENQ_USER_ID -- enqueue user id  

 

NUMBER  

ENQ_TXN_ID -- enqueue transaction id  

NOT NULL  

VARCHAR2(30)  

DEQ_TIME -- dequeue time  

 

DATE  

DEQ_USER_ID -- dequeue user id  

 

NUMBER  

DEQ_TXN_ID -- dequeue transaction id  

 

VARCHAR2(30)  

RETRY_COUNT -- number of retries  

 

NUMBER  

EXCEPTION_QUEUE_OWNER -- exception queue schema  

 

VARCHAR2(30)  

EXCEPTION_QUEUE -- exception queue name  

 

VARCHAR2(30)  

USER_DATA -- user data  

 

BLOB  

SENDER_NAME -- name of the Agent enqueuing the message (valid only for 8.1-compatible queue tables)  

 

VARCHAR2(30)  

SENDER_ADDRESS -- queue name and database name of the source (last propagating) queue; the database name is not specified if the source queue is in the local database (valid only for 8.1-compatible queue tables)  

 

VARCHAR2(1024)  

SENDER_PROTOCOL -- protocol for sender address, reserved for future use (valid only for 8.1-compatible queue tables)  

 

NUMBER  

ORIGINAL_MSGID -- message id of the message in the source queue (valid only for 8.1-compatible queue tables)  

 

RAW(16)  

CONSUMER_NAME -- name of the Agent receiving the message (valid ONLY for 8.1-compatible MULTICONSUMER queue tables)  

 

VARCHAR2(30)  

ADDRESS -- address (queue name and database link name) of the agent receiving the message.The database link name is not specified if the address is in the local database. The address is NULL if the receiving agent is local to the queue (valid ONLY for 8.1-compatible MULTICONSUMER queue tables)  

 

VARCHAR2(1024)  

PROTOCOL -- protocol for receiving agent's address (valid only for 8.1-compatible queue tables)  

 

NUMBER  

PROPAGATED_MSGID -- message id of the message in the receiving agent's queue (valid only for 8.1-compatible queue tables)  

NULL  

RAW(16)  

Select Queue Tables in User Schema

Figure 5-9 Use Case Diagram: Select Queue Tables in User Schema



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

 

Name of View:

USER_QUEUE_TABLES

Syntax:

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.

Table 5-9 USER_QUEUE_TABLES
Column Name & Description  Null?  Type  

QUEUE_TABLE - queue table name  

 

VARCHAR2(30)  

TYPE -- payload type  

 

VARCHAR2(7)  

OBJECT_TYPE -- name of object type, if any  

 

VARCHAR2(61)  

SORT_ORDER -- user specified sort order  

 

VARCHAR2(22)  

RECIPIENTS -- SINGLE or MULTIPLE  

 

VARCHAR2(8)  

MESSAGE_GROUPING -- NONE or TRANSACTIONAL  

 

VARCHAR2(13)  

COMPATIBLE -- indicates the lowest version with which the queue table is compatible  

 

VARCHAR2(5)  

PRIMARY_INSTANCE -- indicates which instance is the primary owner of the queue table; a value of 0 indicates that there is no primary owner  

 

NUMBER  

SECONDARY_INSTANCE -- indicates which owner is the secondary owner of the queue table; this instance becomes the owner of the queue table if the primary owner is not up; a value of 0 indicates that there is no secondary owner  

 

NUMBER  

OWNER_INSTANCE -- indicates which instance currently owns the queue table  

 

NUMBER  

USER_COMMENT -- user comment for the queue table  

 

VARCHAR2(50)  

Select Queues In User Schema

Figure 5-10 .Use Case Diagram: Select Queues in User Schema



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

 

Name of View:

USER_QUEUES

Purpose:

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

Table 5-10 USER_QUEUES
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)  

Select Propagation Schedules in User Schema

Figure 5-11 Use Case Diagram: Select Propagation Schedules in User Schema



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

 

Name:

USER_QUEUE_SCHEDULES

Purpose:

Table 5-11 USER_QUEUE_SCHEDULES
Column Name & Description  Null?  Type  

QNAME -- source queue name  

NOT NULL  

VARCHAR2(30)  

DESTINATION -- destination name, currently limited to be a DBLINK name  

NOT NULL  

VARCHAR2(128)  

START_DATE -- date to start propagation in the default date format  

 

DATE  

START_TIME -- time of day at which to start propagation in HH:MI:SS format  

 

VARCHAR2(8)  

PROPAGATION_WINDOW -- duration in seconds for the propagation window  

 

NUMBER  

NEXT_TIME -- function to compute the start of the next propagation window  

 

VARCHAR2(200)  

LATENCY -- maximum wait time to propagate a message during the propagation window.  

 

NUMBER  

SCHEDULE_DISABLED -- N if enabled Y if disabled and schedule will not be executed  

 

VARCHAR(1)  

PROCESS_NAME -- The name of the SNP background process executing this schedule. NULL if not currently executing  

 

VARCHAR2(8)  

SESSION_ID -- The session ID (SID, SERIAL#) of the job executing this schedule. NULL if not currently executing  

 

VARCHAR2(82)  

INSTANCE -- The OPS instance number executing this schedule  

 

NUMBER  

LAST_RUN_DATE -- The date on the last successful execution  

 

DATE  

LAST_RUN_TIME -- The time of the last successful execution in HH:MI:SS format  

 

VARCHAR2(8)  

CURRENT_START_DATE -- Date at which the current window of this schedule was started  

 

DATE  

CURRENT_START_TIME -- Time of day at which the current window of this schedule was started in HH:MI:SS format  

 

VARCHAR2(8)  

NEXT_RUN_DATE -- Date at which the next window of this schedule will be started  

 

DATE  

NEXT_RUN_TIME -- Time of day at which the next window of this schedule will be started in HH:MI:SS format  

 

VARCHAR2(8)  

TOTAL_TIME -- Total time in seconds spent in propagating messages from the schedule  

 

NUMBER  

TOTAL_NUMBER -- Total number of messages propagated in this schedule  

 

NUMBER  

TOTAL_BYTES -- Total number of bytes propagated in this schedule  

 

NUMBER  

MAX_NUMBER -- The maximum number of messages propagated in a propagation window  

 

NUMBER  

MAX_BYTES -- The maximum number of bytes propagated in a propagation window  

 

NUMBER  

AVG_NUMBER -- The average number of messages propagated in a propagation window  

 

NUMBER  

AVG_SIZE -- The average size of a propagated message in bytes  

 

NUMBER  

AVG_TIME -- The average time, in seconds, to propagate a message  

 

NUMBER  

FAILURES -- The number of times the execution failed. If 16, the schedule will be disabled  

 

NUMBER  

LAST_ERROR_DATE -- The date of the last unsuccessful execution  

 

DATE  

LAST_ERROR_TIME -- The time of the last unsuccessful execution  

 

VARCHAR2(8)  

LAST_ERROR_MSG -- The error number and error message text of the last unsuccessful execution  

 

VARCHAR2(4000)  

Select Queue Subscribers

Figure 5-12 Use Case Diagram: Select Queue Subscribers



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

 

Name of View:

AQ$<queue_table_name>_S

Purpose:

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.

Table 5-12 AQ$<queue_table_name>_S
Column Name & Description  Null?  Type  

QUEUE - name of Queue for which subscriber is defined  

NOT NULL  

VARCHAR2(30)  

NAME - name of Agent  

 

VARCHAR2(30)  

ADDRESS - address of Agent  

 

VARCHAR2(1024)  

PROTOCOL - protocol of Agent  

 

NUMBER  

Usage Notes

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.

Select Queue Subscribers and their Rules

Figure 5-13 Use Case Diagram: Select Queue Subscribers and their Rules



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

 

Name of View:

AQ$<queue_table_name>_R

Purpose:

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.

Table 5-13 AQ$<queue_table_name>_R
Column Name & Description  Null?  Type  

QUEUE - name of Queue for which subscriber is defined  

NOT NULL  

VARCHAR2(30)  

NAME - name of Agent  

 

VARCHAR2(30)  

ADDRESS - address of Agent  

 

VARCHAR2(1024)  

PROTOCOL - protocol of Agent  

 

NUMBER  

RULE - text of defined rule  

 

VARCHAR2(30)  

Select the Number of Messages in Different States for the Whole Database

Figure 5-14 GV$AQ



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

 

Name of View:

GV$AQ

Purpose:

Provides information about the number of messages in different states for the whole database.

Table 5-14 AQ$<queue_table_name>_R
Column Name & Description  Null?  Type  

QID -- the identity of the queue. This is the same as the qid in user_queues and dba_queues.  

 

NUMBER  

WAITING -- the number of messages in the state 'WAITING'.  

 

NUMBER  

READY -- the number of messages in state 'READY'.  

 

NUMBER  

EXPIRED -- the number of messages in state 'EXPIRED'.  

 

NUMBER  

TOTAL_WAIT -- the number of seconds for which messages in the queue have been waiting in state 'READY'  

 

NUMBER  

AVERAGE_WAIT -- the average number of seconds a message in state 'READY' has been waiting to be dequeued.  

 

NUMBER  

Select the Number of Messages in Different States for Specific Instances

Figure 5-15 V$AQ



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

 

Name of View:

V$AQ

Purpose:

Provides information about the number of messages in different states for specific instances.

Table 5-15 AQ$<queue_table_name>_R
Column Name & Description  Null?  Type  

QID -- the identity of the queue. This is the same as the qid in user_queues and dba_queues.  

 

NUMBER  

WAITING -- the number of messages in the state 'WAITING'.  

 

NUMBER  

READY -- the number of messages in state 'READY'.  

 

NUMBER  

EXPIRED -- the number of messages in state 'EXPIRED'.  

 

NUMBER  

TOTAL_WAIT -- the number of seconds for which messages in the queue have been waiting in state 'READY'  

 

NUMBER  

AVERAGE_WAIT -- the average number of seconds a message in state 'READY' has been waiting to be dequeued.  

 

NUMBER  




Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index