10
Administrative Interface: Views

In this chapter we discuss each operation (such as "Selecting All Queue Tables in Database") in terms of a use case by that name. Table 10-1 summarizes the use cases.

Use cases are laid out as follows:

Use case figure. 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 "Selecting 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.
Syntax. The syntax used to perform this activity.

Use Case Model: Administrative Interface--Views

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

Use Case	Name of View
Selecting All Queue Tables in Database	`DBA_QUEUE_TABLES`
Selecting User Queue Tables	`ALL_QUEUE_TABLES`
Selecting All Queues in Database	`DBA_QUEUES`
Selecting All Propagation Schedules	`DBA_QUEUE_SCHEDULES`
Selecting Queues for Which User Has Any Privilege	`ALL_QUEUES`
Selecting Queues for Which User Has Queue Privilege	`QUEUE_PRIVILEGES`
Selecting Messages in Queue Table	`AQ`$`<name of queue table>`
Selecting Queue Tables in User Schema	`USER_QUEUE_TABLES`
Selecting Queues In User Schema	`USER_QUEUES`
Selecting Propagation Schedules in User Schema	`USER_QUEUE_SCHEDULES`
Selecting Queue Subscribers	`AQ$<name of queue table>_S`
Selecting Queue Subscribers and Their Rules	`AQ$<name of queue table>_R`
Selecting the Number of Messages in Different States for the Whole Database	`GV$AQ`
Selecting the Number of Messages in Different States for Specific Instances	`V$AQ`
Selecting the AQ Agents Registered for Internet Access	`AQ$INTERNET_USERS`
Selecting User Transformations	USER_TRANSFORMATIONS
Selecting User Transformation Functions	USER_ATTRIBUTE_TRANSFORMATIONS
Selecting All Transformations	DBA_TRANSFORMATIONS
Selecting All Transformation Functions	DBA_ATTRIBUTE_TRANSFORMATIONS

Selecting All Queue Tables in Database

Figure 10-1 Selecting All Queue Tables in Database

Text description of adque101.gif follows

Text description of the illustration adque101.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

DBA_QUEUE_TABLES

Purpose

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

Table 10-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	-	`VARCHAR`2(22)
`RECIPIENTS`--`SINGLE` or `MULTIPLE`	-	`VARCHAR2(8)`
`MESSAGE_GROUPING--NONE` or `TRANSACTIONAL`	-	`VARCHAR`2(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)`

Selecting User Queue Tables

Figure 10-2 Selecting User Queue Tables

Text description of adque102.gif follows

Text description of the illustration adque102.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

ALL_QUEUE_TABLES

Purpose

This view describes queue tables accessible to a user.

Table 10-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	-	`VARCHAR`2(22)
`RECIPIENTS`--`SINGLE` or `MULTIPLE` recipient queue	-	`VARCHAR2(8)`
`MESSAGE_GROUPING`--`NONE` or `TRANSACTIONAL`	-	`VARCHAR`2(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)`

Selecting All Queues in Database

Figure 10-3 Selecting All Queues in Database

Text description of adque071.gif follows

Text description of the illustration adque071.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

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 10-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`
Q`UEUE_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)`

Selecting All Propagation Schedules

Figure 10-4 Selecting All Propagation Schedules

Text description of adque072.gif follows

Text description of the illustration adque072.gif

Text description of adque073.gif follows

Text description of the illustration adque073.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

DBA_QUEUE_SCHEDULES

Purpose

This view describes the current schedules for propagating messages.

Table 10-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 Real Application Clusters 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)`

Selecting Queues for Which User Has Any Privilege

Figure 10-5 Selecting Queues for Which the User Has Any Privilege

Text description of adque074.gif follows

Text description of the illustration adque074.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

ALL_QUEUES

Purpose

This view describes all queues accessible to the user.

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

Selecting Queues for Which User Has Queue Privilege

Figure 10-6 Selecting Queues for Which the User Has Queue Privilege

Text description of adque075.gif follows

Text description of the illustration adque075.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

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

Selecting Messages in Queue Table

Figure 10-7 Selecting Messages in Queue Table

Text description of adque076.gif follows

Text description of the illustration adque076.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

Select messages in 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 10-8 View for Selecting Messages in a 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)`
`ORIGINAL_QUEUE_NAME`--name of the queue the message came from	-	-
`ORIGINAL_QUEUE_OWNER`--owner of the queue the message came from	-	-
`EXPIRATION_REASON`--the reason the message came into the exception queue. Possible values are `TIME_EXPIRATION` (message expired after the specified expired time), `MAX_RETRY_EXCEEDED` (max. retry count was exceeded), and `PROPAGATION_FAILURE` (message became undeliverable during propagation)	-	-

Selecting Queue Tables in User Schema

Figure 10-8 Selecting Queue Tables in User Schema

Text description of adque077.gif follows

Text description of the illustration adque077.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

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

Selecting Queues In User Schema

Figure 10-9 Selecting Queues in User Schema

Text description of adque078.gif follows

Text description of the illustration adque078.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

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

Selecting Propagation Schedules in User Schema

Figure 10-10 Selecting Propagation Schedules in User Schema

Text description of adque079.gif follows

Text description of the illustration adque079.gif

Text description of adque080.gif follows

Text description of the illustration adque080.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

USER_QUEUE_SCHEDULES

Purpose

Table 10-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 Real Application Clusters 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_TIM`E--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)`

Selecting Queue Subscribers

Figure 10-11 Selecting Queue Subscribers

Text description of adque081.gif follows

Text description of the illustration adque081.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

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. This view also displays the transformation for the subscriber if it was created with one.

Table 10-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`
`TRANSFORMATION`--the name of the transformation can be null	-	`VARCHAR2(61)`

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.

Selecting Queue Subscribers and Their Rules

Figure 10-12 Selecting Queue Subscribers and their Rules

Text description of adque082.gif follows

Text description of the illustration adque082.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

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. The view will also display the transformation for the subscriber if one was specified.

Table 10-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)`
`TRANSFORMATION`--name of transformation specified, can be null	-	`VARCHAR2(61)`

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

Figure 10-13 Selecting the Number of Messages in Different States for the Whole Database

Text description of adque105.gif follows

Text description of the illustration adque105.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

GV$AQ

Purpose

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

Table 10-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`

Selecting the Number of Messages in Different States for Specific Instances

Figure 10-14 Selecting the Number of Messages in Different States for Specific Instances

Text description of adque106.gif follows

Text description of the illustration adque106.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

V$AQ

Purpose

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

Table 10-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`

Selecting the AQ Agents Registered for Internet Access

Figure 10-15 Selecting the AQ Agents Registered for Internet Access

Text description of adque414.gif follows

Text description of the illustration adque414.gif

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

AQ$INTERNET_USERS

Purpose

Provides information about the agents registered for Internet access to AQ. It also provides the list of database users that each Internet agent maps to.

Table 10-16 AQ$INTERNET_USERS

Column Name & Description	Null?	Type
`AGENT_NAME`--the name of the AQ Internet agent	`NOT NULL`	`VARCHAR2(30)`
`DB_USERNAME`--the name of the database user that this Internet agent maps to	`NOT NULL`	`VARCHAR2(30)`
`HTTP_ENABLED`--indicates whether this agent is allowed to access AQ through HTTP. Has a value of YES or NO	-	`VARCHAR2(4)`
`SMTP_ENABLED`--indicates whether this agent is allowed to access AQ through SMTP. Has a value of YES or NO	-	`VARCHAR2(4)`
`FTP_ENABLED`--indicates whether this agent is allowed to access AQ through FTP. Always has a value of NO in current release	-	`VARCHAR2(4)`

Selecting User Transformations

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

USER_TRANSFORMATIONS

Purpose

This view displays all the transformations owned by the user. To view the transformation definition, query USER_ATTRIBUTE_TRANSFORMATIONS.

Table 10-17 USER_TRANSFORMATIONS

Column Name & Description	Null?	Type
TRANSFORMATION_ID--unique id for the transformation	-	NUMBER
NAME--transformation name	-	VARCHAR2(30)
FROM_TYPE--source type name	-	VARCHAR2(61)
TO_TYPE--target type name	-	VARCHAR2(61)

Selecting User Transformation Functions

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

USER_ATTRIBUTE_TRANSFORMATIONS

Purpose

This view displays the transformation functions for all the transformations of the user.

Table 10-18 USER_ATTRIBUTE_TRANSFORMATIONS

Column Name & Description	Null?	Type
TRANSFORMATION_ID--unique id of the transformation	-	NUMBER
NAME--transformation name	-	VARCHAR2(30)
FROM_TYPE--source type name	-	VARCHAR2(61)
TO_TYPE-- target type name	-	VARCHAR2(61`)`
ATTRIBUTE--target type attribute number	-	NUMBER
ATRIBUTE_TRANSFORMATION--transformation function for the attribute	-	VARCHAR2(4000)

Selecting All Transformations

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

DBA_TRANSFORMATIONS

Purpose

This view displays all the transformations in the database. These transformations can be specified with Advanced Queue operations like enqueue, dequeue and subscribe to automatically integrate transformations in AQ messaging. This view is accessible only to users having DBA privileges.

Table 10-19 DBA_TRANSFORMATIONS

Column Name & Description	Null?	Type
`TRANSFORMATION_ID`--unique identifier for the transformation	-	NUMBER
`OWNER`--owning user of the transformation	-	VARCHAR2(30)
`NAME`-- transformation name	-	VARCHAR2(30)
`FROM_TYPE`--source type name	-	VARCHAR2(61)
`TO_TYPE`--target type name	-	VARCHAR2(61)
`Namespace`--one for transformations created by the Oracle transformation engine. Transformations from third party-transformation engines are in different namespaces.	-	-
`From_type_schema`--owning user of the source type	-	-
`From_type_name`--source type of the transformation	-	-
`To_type_Schema`--owning user of the destination type	-	-
`To_type_name`--destination type of the transformation. The transformation takes an object of the source type and returns an object of the destination type.	-	-
`Transformation_type`--type of the transformation. Values: SQL and XSL	-	-
`Attribute_Name`--attribute name of the destination type for which the transformation is being specified.	-	-
`Transformation_Expression`--can be a SQL expression, P/LSQL function, or an XSL document	-	-
`Comment`--user-specified comment.	-	-

Selecting All Transformation Functions

See Also:

Table 10-1 for a list of views in the adminstrative interface

Name of View

DBA_ATTRIBUTE_TRANSFORMATIONS

Purpose

This view displays the transformation functions for all the transformations in the database.

Table 10-20 DBA_ATTRIBUTE_TRANSFORMATIONS

Column Name & Description	Null?	Type
TRANSFORMATION_ID--unique id of the transformation	-	NUMBER
OWNER-- transformation owner	-	VARCHAR2(30)
NAME--transformation name	-	VARCHAR2(30)
FROM_TYPE-- source type name	-	VARCHAR2(61)
TO_TYPE-- target type name	-	VARCHAR2(61)
ATTRIBUTE-- target type attribute number	-	NUMBER
ATRIBUTE_TRANSFORMATION--transformation function for the attribute	-	VARCHAR2(4000)

10 Administrative Interface: Views

Use Case Model: Administrative Interface--Views

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

Selecting All Queue Tables in Database

Figure 10-1 Selecting All Queue Tables in Database

Name of View

Purpose

Table 10-2 DBA_QUEUE_TABLES

Selecting User Queue Tables

Figure 10-2 Selecting User Queue Tables

Name of View

Purpose

Table 10-3 DBA_QUEUE_TABLES

Selecting All Queues in Database

Figure 10-3 Selecting All Queues in Database

Name of View

Purpose

Table 10-4 DBA_QUEUES

Selecting All Propagation Schedules

Figure 10-4 Selecting All Propagation Schedules

Name of View

Purpose

Table 10-5 DBA_QUEUE_SCHEDULES

Selecting Queues for Which User Has Any Privilege

Figure 10-5 Selecting Queues for Which the User Has Any Privilege

Name of View

Purpose

Table 10-6 ALL_QUEUES

Selecting Queues for Which User Has Queue Privilege

Figure 10-6 Selecting Queues for Which the User Has Queue Privilege

Name of View

Purpose

Table 10-7 QUEUE_PRIVILEGES

Selecting Messages in Queue Table

Figure 10-7 Selecting Messages in Queue Table

Name of View

Purpose

Table 10-8 View for Selecting Messages in a Queue Table

Selecting Queue Tables in User Schema

Figure 10-8 Selecting Queue Tables in User Schema

Name of View

Syntax

Table 10-9 USER_QUEUE_TABLES

Selecting Queues In User Schema

Figure 10-9 Selecting Queues in User Schema

Name of View

Purpose

Table 10-10 USER_QUEUES

Selecting Propagation Schedules in User Schema

Figure 10-10 Selecting Propagation Schedules in User Schema

Name of View

Purpose

Table 10-11 USER_QUEUE_SCHEDULES

Selecting Queue Subscribers

Figure 10-11 Selecting Queue Subscribers

Name of View

Purpose

Table 10-12 AQ$<queue_table_name>_S

Usage Notes

Selecting Queue Subscribers and Their Rules

Figure 10-12 Selecting Queue Subscribers and their Rules

Name of View

Purpose

Table 10-13 AQ$<queue_table_name>_R

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

Figure 10-13 Selecting the Number of Messages in Different States for the Whole Database

Name of View

Purpose

Table 10-14 AQ$<queue_table_name>_R

Selecting the Number of Messages in Different States for Specific Instances

Figure 10-14 Selecting the Number of Messages in Different States for Specific Instances

Name of View

Purpose

Table 10-15 AQ$<queue_table_name>_R

Selecting the AQ Agents Registered for Internet Access

Figure 10-15 Selecting the AQ Agents Registered for Internet Access

Name of View

Purpose

Table 10-16 AQ$INTERNET_USERS

Selecting User Transformations

10
Administrative Interface: Views