DBA_HIST_SYSMETRIC_SUMMARY displays a history of statistical summary of all metric values in the System Metrics Long Duration group. This view contains snapshots of V$SYSMETRIC_SUMMARY.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
NOT NULL |
Unique snapshot ID |
DBID |
NUMBER |
NOT NULL |
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number for the snapshot |
BEGIN_TIME |
DATE |
NOT NULL |
Begin time of the interval |
END_TIME |
DATE |
NOT NULL |
End time of the interval |
INTSIZE |
NUMBER |
NOT NULL |
Interval size (in hundredths of a second) |
GROUP_ID |
NUMBER |
NOT NULL |
Group ID |
METRIC_ID |
NUMBER |
NOT NULL |
Metric ID |
METRIC_NAME |
VARCHAR2(64) |
NOT NULL |
Metric name |
METRIC_UNIT |
VARCHAR2(64) |
NOT NULL |
Unit of measurement |
NUM_INTERVAL |
NUMBER |
NOT NULL |
Number of intervals observed |
MINVAL |
NUMBER |
NOT NULL |
Minimum value observed |
MAXVAL |
NUMBER |
NOT NULL |
Maximum value observed |
AVERAGE |
NUMBER |
NOT NULL |
Average over the period |
STANDARD_DEVIATION |
NUMBER |
NOT NULL |
One standard deviation |
SUM_SQUARES |
NUMBER |
Sum of the squared deviations from the mean |