V$EMON

V$EMON displays performance statistics per event monitor (EMON) slave for diagnosability of notifications. All processing time and latency is in seconds.

Column Datatype Description
EMON# NUMBER EMON identifier (0 - 9)
SID NUMBER Session identifier
STARTUP_TIME TIMESTAMP(3) WITH TIME ZONE Time when this EMON slave was started
SERVER_TYPE VARCHAR2(8) Notification quality of the service provided by EMON:

  • REGULAR

  • RELIABLE
STATUS VARCHAR2(6) EMON status:

  • IDLE

  • ACTIVE
STATUS_CHANGE_TIME TIMESTAMP(3) WITH TIME ZONE Time at which EMON switched to the current STATUS
NUM_NTFNS NUMBER Total number of notifications (including grouping notifications)
NUM_GROUPING_NTFNS NUMBER Number of grouping notifications
NUM_NTFNS_ALL_GROUPS NUMBER Total number of events in all notification groups
NUM_OCI_NTFNS NUMBER Number of OCI notifications
NUM_PLSQL_NTFNS NUMBER Number of PL/SQL notifications
NUM_EMAIL_NTFNS NUMBER Number of E-mail notifications
NUM_HTTP_NTFNS NUMBER Number of HTTP notifications
NUM_EVENTS_PROCESSED NUMBER Number of events posted by a publisher for which notifications have been delivered
NUM_EVENTS_PENDING NUMBER Number of events posted by a publisher for which notifications are not yet delivered
NUM_ANONYMOUS_NTFNS NUMBER Number of anonymous notifications
NUM_AQ_NTFNS NUMBER Number of AQ notifications
NUM_DBCHANGE_NTFNS NUMBER Number of DBChange notifications
TOTAL_ANONYMOUS_NTFN_TIME NUMBER Total time to process Anonymous notifications
TOTAL_AQ_NTFN_TIME NUMBER Total time to process AQ notifications
TOTAL_DBCHANGE_NTFN_TIME NUMBER Total time to process dbchange notifications
TOTAL_PLSQL_NTFN_TIME NUMBER Total time to process PL/SQL notifications
TOTAL_OCI_NTFN_TIME NUMBER Total time to process OCI notifications
TOTAL_EMAIL_NTFN_TIME NUMBER Total time to process E-mail notifications
TOTAL_HTTP_NTFN_TIME NUMBER Total time to process HTTP notifications
TOTAL_EMON_LATENCY NUMBER Total latency in processing events
REGISTRATIONS_EXPIRED NUMBER Number of expired registrations
REGISTRATIONS_PURGED NUMBER Number of purged registrations
REGISTRATIONS_INVALID NUMBER Number of registrations invalidated due to notification delivery failure
LAST_UPDATE_TIME TIMESTAMP(3) WITH TIME ZONE Time when statistics were last updated