V$SYSMETRIC displays the system metric values captured for the most current time interval for both the long duration (60-second) and short duration (15-second) system metrics.
| 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 |
VALUE |
NUMBER |
Metric value |
METRIC_UNIT |
VARCHAR2(64) |
Metric unit description |