GV$ALERT_TYPES

SELECT
t.inst_id,               -- INST_ID NUMBER
rid_keltsd,              -- REASON_ID NUMBER
typnam_keltosd,          -- OBJECT_TYPE VARCHAR2(64)
decode                   -- TYPE VARCHAR2(9)
  (typ_keltsd, 1, 'Stateful', 'Stateless'),
nam_keltgsd,             -- GROUP_NAME VARCHAR2(64)
decode                   -- SCOPE VARCHAR2(8)
  (scp_keltsd, 1, 'Database', 'Instance'),
mtn_keltsd,              -- INTERNAL_METRIC_CATEGORY VARCHAR2(64)
mtc_keltsd               -- INTERNAL_METRIC_NAME VARCHAR2(64)
FROM
x$keltsd t,
x$keltosd,
x$keltgsd 
WHERE
grp_keltsd = id_keltgsd AND otyp_keltsd = typid_keltosd
home |  up  |  mailbox