Oracle教程 2023-04-02

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

V$AQ_NOTIFICATION_CLIENTS视图用于查看和管理使用Oracle Streams AQs的客户端会话.通过这个视图可以查看消息传递系统中存在的每一个客户端会话，并可以无缝地将其加入消息队列中使用。

可以使用V$AQ_NOTIFICATION_CLIENTS语句来查看当前与某个消息队列相关的客户端会话列表。语法如下：

SELECT * FROM V$AQ_NOTIFICATION_CLIENTS WHERE QUEUE_NAME = ;

此外，可以使用V$AQ_NOTIFICATION_CLIENTS语句来查看在当前消息队列中某个特定客户端会话的信息。语法如下：

SELECT * FROM V$AQ_NOTIFICATION_CLIENTS WHERE CLIENT_NAME = ;

V$AQ_NOTIFICATION_CLIENTS displays performance statistics for secure OCI client connections.

Column	Datatype	Description
`CLIENT_ID`	`VARCHAR2(29)`	Internally generated client ID for secure notification clients
`EMON_ID`	`NUMBER`	Emon ID serving the client
`NOTIFICATION_STATE`	`NUMBER`	Notification state: `ACTIVE` – Sending notification `WAIT_FOR_ACK` – Waiting for client acknowledgment `INACTIVE` – Idle connection
`NUM_MESSAGE_SENT`	`NUMBER`	Number of messages sent on the connection
`NUM_BYTES_SENT`	`NUMBER`	Number of bytes sent on the connection
`NUM_MESSAGE_RECEIVED`	`NUMBER`	Number of messages successfully received by the client
`LAST_SEND_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Time when the last message was sent on the connection
`LAST_RECEIVE_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Time when the last message was received over the connection
`CONNECT_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Time at which the client connected
`DISCONNECT_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Time at which the client disconnected
`LAST_ERROR`	`NUMBER`	The last error that occurred on the client connection
`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