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