SELECT
EMON#, -- EMON# NUMBER
SID, -- SID NUMBER
STARTUP_TIME, -- STARTUP_TIME TIMESTAMP(3) WITH TIME ZONE
SERVER_TYPE, -- SERVER_TYPE VARCHAR2(8)
STATUS, -- STATUS VARCHAR2(6)
STATUS_CHANGE_TIME, -- STATUS_CHANGE_TIME TIMESTAMP(3) WITH TIME ZONE
NUM_NTFNS, -- NUM_NTFNS NUMBER
NUM_GROUPING_NTFNS, -- NUM_GROUPING_NTFNS NUMBER
NUM_NTFNS_ALL_GROUPS, -- NUM_NTFNS_ALL_GROUPS NUMBER
NUM_OCI_NTFNS, -- NUM_OCI_NTFNS NUMBER
NUM_PLSQL_NTFNS, -- NUM_PLSQL_NTFNS NUMBER
NUM_EMAIL_NTFNS, -- NUM_EMAIL_NTFNS NUMBER
NUM_HTTP_NTFNS, -- NUM_HTTP_NTFNS NUMBER
NUM_EVENTS_PROCESSED, -- NUM_EVENTS_PROCESSED NUMBER
NUM_EVENTS_PENDING, -- NUM_EVENTS_PENDING NUMBER
NUM_ANONYMOUS_NTFNS, -- NUM_ANONYMOUS_NTFNS NUMBER
NUM_AQ_NTFNS, -- NUM_AQ_NTFNS NUMBER
NUM_DBCHANGE_NTFNS, -- NUM_DBCHANGE_NTFNS NUMBER
TOTAL_ANONYMOUS_NTFN_TIME, -- TOTAL_ANONYMOUS_NTFN_TIME NUMBER
TOTAL_AQ_NTFN_TIME, -- TOTAL_AQ_NTFN_TIME NUMBER
TOTAL_DBCHANGE_NTFN_TIME, -- TOTAL_DBCHANGE_NTFN_TIME NUMBER
TOTAL_PLSQL_NTFN_TIME, -- TOTAL_PLSQL_NTFN_TIME NUMBER
TOTAL_OCI_NTFN_TIME, -- TOTAL_OCI_NTFN_TIME NUMBER
TOTAL_EMAIL_NTFN_TIME, -- TOTAL_EMAIL_NTFN_TIME NUMBER
TOTAL_HTTP_NTFN_TIME, -- TOTAL_HTTP_NTFN_TIME NUMBER
TOTAL_EMON_LATENCY, -- TOTAL_EMON_LATENCY NUMBER
REGISTRATIONS_EXPIRED, -- REGISTRATIONS_EXPIRED NUMBER
REGISTRATIONS_PURGED, -- REGISTRATIONS_PURGED NUMBER
REGISTRATIONS_INVALID, -- REGISTRATIONS_INVALID NUMBER
LAST_UPDATE_TIME -- LAST_UPDATE_TIME TIMESTAMP(3) WITH TIME ZONE
FROM
GV$EMON
WHERE
INST_ID = USERENV('INSTANCE')