Enterprise Manager Generic (MOSC)

MOSC Banner

displaying additional information in a metric extension

edited Jan 22, 2020 9:26AM in Enterprise Manager Generic (MOSC) 1 commentAnswered ✓

I am trying to extract some repository side information for a metric extension on some MQ targets. I'm using mgmt$metric_current and can select more or less what I want from the following sql

SELECT target_guid, key_value,

        value AS ROBIN

FROM   mgmt$metric_current

WHERE  target_type = 'wmq'

                 AND metric_label = 'Local Queues'

                 AND metric_column = 'PercentUsage'  

                 AND value > 0  

order by to_number(value)  desc

I have 2 columns here - key_value and ROBIN -

This returns data from all queues where we have a positive percent used (often many rows) but as I'm sorting I get the worst offender first.

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