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 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	-	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 User Queue Tables

Figure 10-2 Selecting User Queue Tables

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

Selecting All Queues in Database

Figure 10-3 Selecting All Queues in Database

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
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 All Propagation Schedules

Figure 10-4 Selecting All Propagation Schedules

Text description of the illustration adque072.gif


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 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 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 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 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 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 the illustration adque079.gif


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_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 Queue Subscribers

Figure 10-11 Selecting Queue Subscribers

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