V$SYSMETRIC_SUMMARY

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