在使用EM图形界面查看数据库cpu使用率时,发现查看较久的信息的话就不准确,下面提供sql直接查看
--- sysman.MGMT$METRIC_DETAILS
--- sysman.MGMT$METRIC_DAILY
--- sysman.MGMT$METRIC_DETAILS
select mmd.TARGET_NAME,
mmd.METRIC_LABEL,
mmd.COLUMN_LABEL,
mmd.COLLECTION_TIMESTAMP,
mmd.VALUE
from sysman.MGMT$METRIC_DETAILS mmd
where mmd.TARGET_NAME = '
<Target Name>
'
and mmd.TARGET_TYPE = 'host'
and mmd.column_label in ('CPU Utilization (%)') -- Metric Name as seen in console
and mmd.collection_timestamp > (sysdate - 5) -- limiting history (max 7 days [Default])
order by mmd.collection_timestamp;
---
sysman.MGMT$METRIC_HOURLY
select mmh.TARGET_NAME,
mmh.METRIC_LABEL,
mmh.COLUMN_LABEL,
mmh.rollup_TIMESTAMP,
mmh.minimum,
mmh.maximum,
mmh.AVERAGE,
mmh.STANDARD_DEVIATION
from sysman.MGMT$METRIC_HOURLY mmh
where mmh.TARGET_NAME = '<Target Name>'
and mmh.TARGET_TYPE = 'host'
and mmh.column_label in ('CPU Utilization (%)') -- Metric Name as seen in console
and mmh.rollup_timestamp > (sysdate - 14) -- limiting history (max 31 days [Default])
order by mmh.rollup_timestamp;
--- sysman.MGMT$METRIC_DAILY
select mmd.TARGET_NAME,
mmd.METRIC_LABEL,
mmd.COLUMN_LABEL,
mmd.rollup_TIMESTAMP,
mmd.minimum,
mmd.maximum,
mmd.AVERAGE,
mmd.STANDARD_DEVIATION
from sysman.MGMT$METRIC_DAILY mmd
where mmd.TARGET_NAME = '<Target Name>'
and mmd.TARGET_TYPE = 'host'
and mmd.column_label in ('CPU Utilization (%)') -- Metric Name as seen in console
and mmd.rollup_timestamp > (sysdate - 31) -- limiting history (max 365 days [Default])
order by mmd.rollup_timestamp;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29953799/viewspace-1973111/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29953799/viewspace-1973111/