order by decode query results different in OEM 12.1.0.5 Information Publisher Reports than Toad
I am using Oracle oem 12.1.0.5 Information Publisher Reports to gather some information about server memory usage in our Oracle Windows env.
The below query in Toad gives me the expected results in toad:
SELECT target_name "Server Name",
round(avg(average),2) "Avg Server Mem Used %",
round(max(maximum), 2) "Max Server Mem Used %"
FROM MGMT$METRIC_DAILY
WHERE target_name in ('PRODARGUSDB.acorda.com', 'VALARGUSDB.acorda.com', 'Prod-MonitorORA.acorda.com', 'DEV2ARGUSDB.acorda.com')
AND metric_name = 'Load'
and metric_column = 'memUsedPct'
AND (rollup_timestamp >= (trunc(add_months(sysdate, -1), 'MM') + 23) and rollup_timestamp <= (trunc(sysdate, 'MM') + 22))
group by target_name