VIEW: SYS.DBA_THRESHOLDS

Source

View Text - Preformatted

select m.name AS metrics_name,
            decode(a.warning_operator, 0, 'GT',
                                       1, 'EQ',
                                       2, 'LT',
                                       3, 'LE',
                                       4, 'GE',
                                       5, 'CONTAINS',
                                       6, 'NE',
                                       7, 'DO NOT CHECK',
                                          'NONE') AS warning_operator,
            a.warning_value AS warning_value,
            decode(a.critical_operator, 0, 'GT',
                                        1, 'EQ',
                                        2, 'LT',
                                        3, 'LE',
                                        4, 'GE',
                                        5, 'CONTAINS',
                                        6, 'NE',
                                        7, 'DO_NOT_CHECK',
                                           'NONE') AS critical_operator,
            a.critical_value AS critical_value,
            a.observation_period AS observation_period,
            a.consecutive_occurrences AS consecutive_occurrences,
            decode(a.instance_name, ' ', null,
                                       instance_name) AS instance_name,
            o.typnam_keltosd AS object_type,
            a.object_name AS object_name,
            decode(a.flags, 1, 'VALID',
                            0, 'INVALID') AS status
  FROM table(dbms_server_alert.view_thresholds) a,
       X$KEWMDSM m,
       X$KELTOSD o
  WHERE a.object_type != 2
    AND m.metricid(+) = a.metrics_id
    AND a.object_type = o.typid_keltosd
  UNION
     select m.name AS metrics_name,
            decode(a.warning_operator, 0, 'GT',
                                       1, 'EQ',
                                       2, 'LT',
                                       3, 'LE',
                                       4, 'GE',
                                       5, 'CONTAINS',
                                       6, 'NE',
                                       7, 'DO_NOT_CHECK',
                                          'NONE') AS warning_operator,
            a.warning_value AS warning_value,
            decode(a.critical_operator, 0, 'GT',
                                        1, 'EQ',
                                        2, 'LT',
                                        3, 'LE',
                                        4, 'GE',
                                        5, 'CONTAINS',
                                        6, 'NE',
                                        7, 'DO NOT CHECK',
                                           'NONE') AS critical_operator,
            a.critical_value AS critical_value,
            a.observation_period AS observation_period,
            a.consecutive_occurrences AS consecutive_occurrences,
            decode(a.instance_name, ' ', null,
                                       instance_name) AS instance_name,
            o.typnam_keltosd AS object_type,
            f.name AS object_name,
            decode(a.flags, 1, 'VALID',
                            0, 'INVALID') AS status
  FROM table(dbms_server_alert.view_thresholds) a,
       X$KEWMDSM m, sys.v$dbfile f, X$KELTOSD o
  WHERE a.object_type = 2
    AND m.metricid = a.metrics_id
    AND a.object_id = f.file#
    AND a.object_type = o.typid_keltosd

View Text - HTML Formatted

SELECT M.NAME AS METRICS_NAME
, DECODE(A.WARNING_OPERATOR
, 0
, 'GT'
, 1
, 'EQ'
, 2
, 'LT'
, 3
, 'LE'
, 4
, 'GE'
, 5
, 'CONTAINS'
, 6
, 'NE'
, 7
, 'DO NOT CHECK'
, 'NONE') AS WARNING_OPERATOR
, A.WARNING_VALUE AS WARNING_VALUE
, DECODE(A.CRITICAL_OPERATOR
, 0
, 'GT'
, 1
, 'EQ'
, 2
, 'LT'
, 3
, 'LE'
, 4
, 'GE'
, 5
, 'CONTAINS'
, 6
, 'NE'
, 7
, 'DO_NOT_CHECK'
, 'NONE') AS CRITICAL_OPERATOR
, A.CRITICAL_VALUE AS CRITICAL_VALUE
, A.OBSERVATION_PERIOD AS OBSERVATION_PERIOD
, A.CONSECUTIVE_OCCURRENCES AS CONSECUTIVE_OCCURRENCES
, DECODE(A.INSTANCE_NAME
, ' '
, NULL
, INSTANCE_NAME) AS INSTANCE_NAME
, O.TYPNAM_KELTOSD AS OBJECT_TYPE
, A.OBJECT_NAME AS OBJECT_NAME
, DECODE(A.FLAGS
, 1
, 'VALID'
, 0
, 'INVALID') AS STATUS
FROM TABLE(DBMS_SERVER_ALERT.VIEW_THRESHOLDS) A
, X$KEWMDSM M
, X$KELTOSD O
WHERE A.OBJECT_TYPE != 2
AND M.METRICID(+) = A.METRICS_ID
AND A.OBJECT_TYPE = O.TYPID_KELTOSD UNION SELECT M.NAME AS METRICS_NAME
, DECODE(A.WARNING_OPERATOR
, 0
, 'GT'
, 1
, 'EQ'
, 2
, 'LT'
, 3
, 'LE'
, 4
, 'GE'
, 5
, 'CONTAINS'
, 6
, 'NE'
, 7
, 'DO_NOT_CHECK'
, 'NONE') AS WARNING_OPERATOR
, A.WARNING_VALUE AS WARNING_VALUE
, DECODE(A.CRITICAL_OPERATOR
, 0
, 'GT'
, 1
, 'EQ'
, 2
, 'LT'
, 3
, 'LE'
, 4
, 'GE'
, 5
, 'CONTAINS'
, 6
, 'NE'
, 7
, 'DO NOT CHECK'
, 'NONE') AS CRITICAL_OPERATOR
, A.CRITICAL_VALUE AS CRITICAL_VALUE
, A.OBSERVATION_PERIOD AS OBSERVATION_PERIOD
, A.CONSECUTIVE_OCCURRENCES AS CONSECUTIVE_OCCURRENCES
, DECODE(A.INSTANCE_NAME
, ' '
, NULL
, INSTANCE_NAME) AS INSTANCE_NAME
, O.TYPNAM_KELTOSD AS OBJECT_TYPE
, F.NAME AS OBJECT_NAME
, DECODE(A.FLAGS
, 1
, 'VALID'
, 0
, 'INVALID') AS STATUS
FROM TABLE(DBMS_SERVER_ALERT.VIEW_THRESHOLDS) A
, X$KEWMDSM M
, SYS.V$DBFILE F
, X$KELTOSD O
WHERE A.OBJECT_TYPE = 2
AND M.METRICID = A.METRICS_ID
AND A.OBJECT_ID = F.FILE#
AND A.OBJECT_TYPE = O.TYPID_KELTOSD