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.
1 2 3 4 5 6 7 8 |
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! 🙂
Jacob