DBA Data[Home] [Help]

VIEW: SYS.V_$AQ_NOTIFICATION_CLIENTS

Source

View Text - Preformatted

select "CLIENT_ID","EMON_ID","NOTIFICATION_STATE","NUM_MESSAGE_SENT","NUM_BYTES_SENT","NUM_MESSAGE_RECEIVED","LAST_SEND_TIME","LAST_RECEIVE_TIME","CONNECT_TIME","DISCONNECT_TIME","LAST_ERROR","CON_ID" from v$aq_notification_clients
View Text - HTML Formatted

SELECT "CLIENT_ID"
, "EMON_ID"
, "NOTIFICATION_STATE"
, "NUM_MESSAGE_SENT"
, "NUM_BYTES_SENT"
, "NUM_MESSAGE_RECEIVED"
, "LAST_SEND_TIME"
, "LAST_RECEIVE_TIME"
, "CONNECT_TIME"
, "DISCONNECT_TIME"
, "LAST_ERROR"
, "CON_ID"
FROM V$AQ_NOTIFICATION_CLIENTS