EM12c Metric Extension output

I made a Metric Extension called dblink.

Al it does is :

SELECT  d.name ||':'

  ||':'  || dbl.owner

  ||':'  || dbl.db_link

  ||':'  || dbl.username
  ||':'  || dbl.host

  ||':'  || dbl.created RIJ

, 'DBLINKINFO:' text

FROM dba_db_links dbl,

  v$database d

Next I added rij as the key column and tekst as the value column.

Next Next Finish

Deploy to targets

And now you can see ALL your database links from a single point of view in your EM12C repository database.

select entity_name,metric_key_value, count(*)

from GC_METRIC_STR_VALUES a

where metric_group_label='dblink'

group by entity_name,metric_key_value

Regards

Dik Pater

The Netherlands