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

See Also: Oracle AI Database Transactional Event Queues and Advanced Queuing User’s Guide for more information about Oracle Database Advanced Queueing