I have both SELECT ANY TABLE and SELECT ANY DICTIOMARY roles on the SYSMAN schema, but I am not able to see data from many views. I tried a very simple query below and no results returned. After digging into this I found I could access all the base tables that this view and others call like em_metric_columns, em_metric_groups, etc. except em_manageable_entities table. The statistics show there is over 7k rows, but when I query the em_manageable_entities table or get a count it shows zero results.
Any suggestions you could provide would be greatly appreciated.
Thank you.
SELECT column_label, value
FROM mgmt$metric_current
WHERE metric_name = 'Load'
AND metric_column = 'cpuUtil'
AND target_name = '...com'