V$SYSMETRIC_SUMMARY displays a summary of all system Metric values for the long-duration system metrics. The average, maximum value, minimum value, and the value of one standard deviation for the last hour are displayed for each metric item.
| Column | Datatype | Description |
|---|---|---|
BEGIN_TIME |
DATE |
Begin time of the interval |
END_TIME |
DATE |
End time of the interval |
INTSIZE_CSEC |
NUMBER |
Interval size (in hundredths of a second) |
GROUP_ID |
NUMBER |
Metric group ID |
METRIC_ID |
NUMBER |
Metric ID |
METRIC_NAME |
VARCHAR2(64) |
Metric name |
NUM_INTERVAL |
NUMBER |
Number of intervals observed |
MAXVAL |
NUMBER |
Maximum value observed |
MINVAL |
NUMBER |
Minimum value observed |
AVERAGE |
NUMBER |
Average value over the period |
STANDARD_DEVIATION |
NUMBER |
One standard deviation |
METRIC_UNIT |
VARCHAR2(64) |
Metric unit description |