Oracle教程 2023-02-24

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

V$AQ_NONDUR_REGISTRATIONS动态视图显示所有当前非持久性代理的登记情况。它报告由客户端应用程序使用非持久性注册以接收消息的所有事件。

V$AQ_NONDUR_REGISTRATIONS视图允许您查看当前正在进行的非持久性订阅。查看下表，每个订阅的每条记录代表一个订阅块，并显示主题、队列名称、客户端标识、深度和超时等登记详细信息。

可以使用V$AQ_NONDUR_REGISTRATIONS视图来执行以下操作：

– 确定消息队列中有哪些订阅
– 检查一个特定的客户端应用程序是否注册了一个特定的主题
– 了解客户端应用程序是如何注册的

V$AQ_NONDUR_REGISTRATIONS provides information about non-durable subscriptions.

Column	Datatype	Description
`REG_ID`	`NUMBER`	Registration ID
`SUBSCRIPTION`	`VARCHAR2(128)`	Subscription name
`LOCATION`	`VARCHAR2(256)`	Location name
`USER#`	`NUMBER`	User ID
`USER_CONTEXT`	`RAW(32)`	Context the user provided
`CONTEXT_SIZE`	`NUMBER`	Size of the context
`NAMESPACE`	`NUMBER`	Subscription namespace
`VERSION`	`NUMBER`	Database version number
`STATE`	`NUMBER`	State of the registration: `ENABLED`: The registration is enabled for notification `STOPPING`: The registration is in a transient state before it becomes `DISABLED` `DISABLED`: The registration is disabled for notification `DEAD`: The registration does not exist any more, and it is marked for deferred cleanup.
`QOS`	`NUMBER`	Quality of service
`REG_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Time of registration
`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