zz$metric

From zzat
Jump to: navigation, search

zz$metric is a core zztat table that stores details on the zztat metrics.

It has the following columns:

Column Name Data Type Description
zz$db number Database DBID from zz$db.
name varchar2 Name of the metric. Limited to a maximum of 12 characters.
flags number Flags configure the behavior of the metric.
snap number For standard metrics. Snapshot calendar interval. Combined with snap_unit to form the Oracle scheduler calendaring expression that defines when to execute the snapshot.
snap_unit varchar2 For standard metrics. Snapshot calendar frequency. Combined with snap to form the Oracle scheduler calendaring expression.
replicate number For standard metrics. Replication calendar interval. Combined with replicate_unit to form the Oracle scheduler calendaring expression that defines when to execute the replication.
replicate_unit varchar2 For standard metrics. Replication calendar frequency. Combined with the replicate interval to form the Oracle scheduler calendaring expression.
part_interval varchar2 Partition view soft-partitioning interval. One of DAY, WEEK, MONTH, or NONE when disabled.
metric_table varchar2 Defaults to zz${metric_name}. Can be set only at metric creation time to have multiple metrics store data in the same table.
query CLOB The metric query.
comments varchar2 Descriptive comment.
hints varchar2 Hints to be injected into the query.
metric_hash raw Auto-generated hash that changes when the metric has been changed. Used for metric synchronization from the repository to targets.
metric_date date Auto-generated date that changes when the metric has been changed. Used for metric synchronization from the repository to targets.