Query to get CPU and Memory usage from OEM database

Please use the below query for a period.

SELECT to_char(rollup_timestamp,’DD-MON-YY HH24′) “Date”, average “CPU Usage %”
FROM sysman.MGMT\$METRIC_HOURLY
WHERE target_name like ‘%servername%’
AND metric_name = ‘Load’
AND metric_column = ‘cpuUtil’
AND trunc(rollup_timestamp) between ‘$MONTH_STDATE’ and ‘$MONTH_EDDATE’;

SELECT to_char(rollup_timestamp,’DD-MON-YY HH24′) “Date”, average “Memory Usage %”
FROM sysman.MGMT\$METRIC_HOURLY
WHERE target_name like ‘%servername%’
AND metric_name = ‘Load’
AND metric_column = ‘memUsedPct’
AND trunc(rollup_timestamp) between ‘$MONTH_STDATE’ and ‘$MONTH_EDDATE’;