Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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