V$THRESHOLD_TYPES definition in Oracle Database 11.2
V$THRESHOLD_TYPES

SELECT
  metrics_id,                              -- METRICS_ID NUMBER
  metrics_group_id,                        -- METRICS_GROUP_ID NUMBER
  operator_mask,                           -- OPERATOR_MASK NUMBER
  object_type,                             -- OBJECT_TYPE VARCHAR2(64)
  alert_reason_id,                         -- ALERT_REASON_ID NUMBER
  metric_value_type                        -- METRIC_VALUE_TYPE NUMBER
FROM
  gv$threshold_types
WHERE
  inst_id = USERENV('INSTANCE')

home |  up