V$ALERT_TYPES

V$ALERT_TYPES displays information about server alert types.

Column Datatype Description
REASON_ID NUMBER ID of the alert reason
OBJECT_TYPE VARCHAR2(64) Object type
TYPE VARCHAR2(9) Alert type:

  • Stateful

  • Stateless
GROUP_NAME VARCHAR2(64) Group name
SCOPE VARCHAR2(8) Scope:

  • Database

  • Instance
INTERNAL_METRIC_CATEGORY VARCHAR2(64) Internal metric category
INTERNAL_METRIC_NAME VARCHAR2(64) Internal metric name