EM 13c: Why Different COLLECTION_NAME Is Seen For Same METRIC_NAME On Different EM Repos Views (MGMT$TARGET_METRIC_COLLECTIONS & MGMT$TEMPLATE_METRICCOLLECTION)
(Doc ID 2860863.1)
Last updated on MAY 26, 2022
Applies to:
Enterprise Manager Base Platform - Version 13.4.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
Why do we see different COLLECTION_NAME for same METRIC_NAME on different EM Repos views (MGMT$TARGET_METRIC_COLLECTIONS & MGMT$TEMPLATE_METRICCOLLECTION)
Example:
SQL> select distinct metric_name, collection_name from MGMT$TARGET_METRIC_COLLECTIONS
where target_type in ('oracle_database')
and targeT_name='<TARGET_NAME>'
and collection_name='oracle_security_cdb'
order by collection_name
METRIC_NAME COLLECTION_NAME
------------------------------ ------------------------------
tableSpaces_cdb oracle_security_cdb
auditSettings_cdb oracle_security_cdb
SQL> select * from MGMT$TEMPLATE_METRICCOLLECTION
where target_type in ('oracle_database')
and template_name='<TEMPLATE_NAME>'
order by collection_name;
METRIC_NAME COLLECTION_NAME
------------------------------ ------------------------------
tableSpaces_cdb tableSpaces_cdb
auditSettings_cdb auditSettings_cdb
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |