GV$INCMETER_SUMMARY definition in Oracle Database 11.2
GV$INCMETER_SUMMARY

select
  inst_id,                                 -- INST_ID NUMBER
  decode(                                  -- SEVERITY_INDEX VARCHAR2(14)
    severity_idx, 0, 'NORMAL', 1, 'WARNING', 2, 'CRITICAL', 'UNKNOWN       '),
  critical_incidents,                      -- CRITICAL_INICDENTS NUMBER
  warning_incidents,                       -- WARNING_INCIDENTS NUMBER
  last_hour_incidents,                     -- LAST_HOUR_INCIDENTS NUMBER
  ctime,                                   -- CREATE_TIME TIMESTAMP(13) WITH TIME ZONE
  otictime,                                -- OLDEST_TRANSIENT_INC_CTIME TIMESTAMP(13) WITH TIME ZONE
  opictime,                                -- OLDEST_PERSISTENT_INC_CTIME TIMESTAMP(13) WITH TIME ZONE
  lictime                                  -- LATEST_INC_CTIME TIMESTAMP(13) WITH TIME ZONE
from
  x$dbkincmetsummary

home |  up