V$AQ_NOTIFICATION

8.30 V$AQ_NOTIFICATION_CLIENTS

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