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')