V$CON_SYSMETRIC

7.138 V$CON_SYSMETRIC_SUMMARY

V$CON_SYSMETRIC_SUMMARY displays a summary of all system metric values for the PDB 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
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: When queried from a non-CDB, the statistics for that instance are returned, and the `CON_ID` value is `0`. When queried from the root of a CDB, the statistics for every container are returned, and the `CON_ID` value indicates the container to which the statistics belong. When queried from a PDB, statistics from that PDB are returned, and the `CON_ID` value is the container ID for that PDB.