V$EMON definition in Oracle Database 11.2
V$EMON

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')

home |  up