Oracle教程 2023-04-03

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

V$EQ_NONDUR_SUBSCRIBER是Oracle的Data Guard特有的视图，用于查询当前数据库中的所有非持久订阅者的状态。

使用方法：

1、首先，打开SQL*Plus，连接到当前数据库；

2、敲入以下查询：

SELECT * FROM V$EQ_NONDUR_SUBSCRIBER;

3、执行这条查询语句，即可查询到当前数据库中所有非持久订阅者的状态信息。

V$EQ_NONDUR_SUBSCRIBER provides information about the non-durable subscriptions on Transactional Event Queues (TEQs).

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. Possible values: `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. Possible values: `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

Note:

This view is available starting with Oracle Database 21c.