This discussion is archived
4 Replies Latest reply: Jul 24, 2013 12:08 PM by user10991645 RSS

OEM 12c Backend Views Owned By SYSMAN

user10991645 Newbie
Currently Being Moderated

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'

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points