EM 13c: No Data Found in MGMT$METRIC_HOURLY and MGMT$METRIC_DAILY views
(Doc ID 2541219.1)
Last updated on NOVEMBER 17, 2019
Applies to:
Enterprise Manager Base Platform - Version 13.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
No data found in sysman.MGMT$METRIC_HOURLY, sysman.MGMT$METRIC_DAILY views
SQL> select table_name, partitions_retained from em_int_partitioned_tables
where table_name in ('EM_METRIC_VALUES_E','EM_METRIC_VALUES_HOURLY_E','EM_METRIC_VALUES_DAILY_E');
TABLE_NAME PARTITIONS_RETAINED
------------------------------ -------------------
EM_METRIC_VALUES_E 7
EM_METRIC_VALUES_HOURLY_E 32
EM_METRIC_VALUES_DAILY_E 24
SQL> select count(*) from sysman.MGMT$METRIC_HOURLY;
COUNT(*)
----------
0
SQL> select count(*) from sysman.MGMT$METRIC_DAILY;
COUNT(*)
----------
0
Changes
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 |
Changes |
Cause |
Solution |
References |