GV$SYSMETRIC
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) value, -- VALUE NUMBER unit -- METRIC_UNIT VARCHAR2(64) FROM x$kewmdrmv WHERE flag1 = 1 AND groupid in (2, 3)

home |  up  |  mailbox