SELECT
  reason_id,                               -- REASON_ID NUMBER
  object_type,                             -- OBJECT_TYPE VARCHAR2(64)
  type,                                    -- TYPE VARCHAR2(9)
  group_name,                              -- GROUP_NAME VARCHAR2(64)
  scope,                                   -- SCOPE VARCHAR2(8)
  internal_metric_category,                -- INTERNAL_METRIC_CATEGORY VARCHAR2(64)
  internal_metric_name                     -- INTERNAL_METRIC_NAME VARCHAR2(64)
FROM
  gv$alert_types
WHERE
  inst_id = USERENV('INSTANCE')