GV$SYSMETRIC_SUMMARY

SELECT
inst_id,                 -- INST_ID NUMBER
begtime,                 -- BEGIN_TIME DATE
endtime,                 -- END_TIME DATE
intsize_csec,            -- INTSIZE_CSEC NUMBER
groupid,                 -- GROUP_ID NUMBER
metricid,                -- METRIC_ID NUMBER
name,                    -- METRIC_NAME VARCHAR2(64)
numintv,                 -- NUM_INTERVAL NUMBER
max,                     -- MAXVAL NUMBER
min,                     -- MINVAL NUMBER
avg,                     -- AVERAGE NUMBER
std,                     -- STANDARD_DEVIATION NUMBER
unit                     -- METRIC_UNIT VARCHAR2(64)
FROM
x$kewmsmdv 
WHERE
groupid = 2
home |  up  |  mailbox