Tablespace % used metric - limits?
Using agent 12.1.0.4.10, emcc 12.1.0.4(?) on an instance with lots of tablespaces, not seeing that the %full metric is working for all tablespaces, posting a snippet from gcagent.log:
====
...
<timestamp> ...columns: [name:STRING, pctUsed:NUMERIC, bytesFree:NUMERIC] rows: {
,,,
#109=<SYSAUX,64.37,1781.5>,#110=<SYSTEM,36.7359375,2530.5625>...
====
And the emcc All Metrics page seems to confirm that, only 110 tablespaces show on the metric threshold "add" tablespace button. Total tablespace count is 180 including temp, undo. Have not installed agent db plugins, is that what we're missing?
Edit: add result snippets from one (plus and an outer join too) of the queries in note 1541511.1
====
SELECT TABLESPACE_NAME TBSP_NAME
, USED_SPACE