在使用EM图形界面查看数据库cpu使用率时，发现查看较久的信息的话就不准确，下面提供sql直接查看

---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博客

在EM数据库内查看监控数据库的cpu使用率