EM12c: Metric Extensions Adapters

It’s for sure that Metric Extensions provide great flexibility to define your own metrics and enhance the monitoring abilities of Oracle Enterprise Manager Cloud Control. There are different adapters for different target types. You can see the available adapters when you pick a target at the “create new metric extension” page.

There are about 130 different target types, so I wondered if it’s possible to write a query to show available adapters for each target type.

SELECT DISTINCT t.type_display_name Target, 
  NVL(a.display_name,'SQL') adapter
FROM em_mext_adapter_props_def d, 
  em_mext_adapters a, 
  em_target_types t 
WHERE a.adapter_name = d.adapter_name 
AND t.target_type = d.target_type 
ORDER BY 1, 2;

SELECT DISTINCT t.type_display_name Target,

NVL(a.display_name,'SQL') adapter

FROM em_mext_adapter_props_def d,

em_mext_adapters a,

em_target_types t

WHERE a.adapter_name = d.adapter_name

AND t.target_type = d.target_type

ORDER BY 1, 2;

After digging the tables of Enterprise Manager repository, I came up with the above query. Here’s the output:

If you’re wondering how you can use these adapters, you can get detailed information in Oracle Documents. By the way, the documentation is sufficient but I’m planning to write blog series to demonstrate how we can use each adapter type. So stay tuned! 🙂

Please share