zz$gauge override

From zzat
Jump to: navigation, search

zz$gauge_override stores override values for the gauges.

It has the following columns:

Column Name Data Type Description
zz$db number Database DBID from zz$db.
name varchar2 Name of the gauge. Limited to 13 characters. The name, together with zz$db form the unique row identifier.
col# number References the column in zz$gauge_cols.col# to override.
override_name varchar2 Identifies the override by name. Must be unique between zz$db,name,col#.
comments varchar2 Describes the override
value_num number Currently unused.
value_varchar varchar2 Currently unused.
value_date date Currently unused.
infovalue_num number Stores the numeric informational column value to match against. If matched, the override value is in effect.
infovalue_varchar varchar2 Stores the string informational column value to match against. If matched, the override value is in effect.
infovalue_date date Stores the date informational column value to match against. If matched, the override value is in effect.
col_warn_limit_num number Override warning threshold numeric value.
col_crit_limit_num number Override critical threshold numeric value.
col_warn_limit_varchar varchar2 Override warning threshold string value.
col_crit_limit_varchar varchar2 Override critical threshold string value.
col_warn_limit_date date Override warning threshold date value.
col_crit_limit_date date Override critical threshold date value.
override_hash raw Auto-generated hash that changes when the gauge override has been changed. Used for gauge synchronization from the repository to targets.
override_date date Auto-generated date that changes when the gauge override has been changed. Used for gauge synchronization from the repository to targets.