Oracle教程 2023-03-27

Oracle 视图 V$AQ_NONDUR_SUBSCRIBER 官方解释，作用，如何使用详细说明

本站中文解释

V$AQ_NONDUR_SUBSCRIBER是Oracle中的一种虚拟视图，它可以提供一个视图，用于检查特定消息订阅者的信息（消息类型或显示订阅者状态）。可以通过使用这个视图来检查非持久性非持久订阅者的消息类型信息。其用法如下：

SELECT * FROM V$AQ_NONDUR_SUBSCRIBER WHERE name=’Name_of_Subscriber’;

该查询会返回指定订阅者的所有信息，其中包括name、qos_name、transformation、forward_agent和status等。

官方英文解释

V$AQ_NONDUR_SUBSCRIBER provides information about the non-durable subscriptions on sharded queues.

Note:

AQ sharded queues are deprecated in Oracle Database 21c. Oracle recommends that you instead use Transactional Event Queues (TEQs) for higher throughput and better performance.

Column	Datatype	Description
`QUEUE_ID`	`NUMBER`	Queue ID
`SUBSCRIBER_ID`	`NUMBER`	ID of the non-durable subscriber
`SUBSCRIBER_NAME`	`VARCHAR2(128)`	Subscriber name
`RULE_CONDITION`	`VARCHAR2(4000)`	Rule condition of the subscriber
`TRANSFORMATION_OWNER`	`VARCHAR2(128)`	Owner of the transformation (for JMS queues)
`TRANSFORMATION_NAME`	`VARCHAR2(128)`	Name of the transformation (for JMS queues)
`CREATION_TIME`	`TIMESTAMP(1) WITH TIME ZONE`	Non-durable subscriber creation time
`FLAGS`	`NUMBER`	Property of the subscriber: `0x0001` – Persistent subscriber `0x0002` – Buffered subscriber `0x0004` – JMS subscriber `0x0008` – Rule-based subscriber `0x0010` – Subscriber has transformation `0x0020` – Notification-only non-durable subscriber subscriber
`SUBSCRIBER_TYPE`	`NUMBER`	Type of subscriber: `1` – JMS non-durable subscriber `2` – Service layer dummy non-durable subscriber `3` – Notification-only non-durable subscriber
`BITPOS`	`NUMBER`	Position of subscriber in subscriber bitmap
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

本站中文解释

官方英文解释

相关推荐