Enterprise Manager Generic (MOSC)

MOSC Banner

order by decode query results different in OEM 12.1.0.5 Information Publisher Reports than Toad

edited Sep 29, 2015 10:03AM in Enterprise Manager Generic (MOSC) 2 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center