DBA_HIST_SYSMETRIC_HISTORY Does Not Capture All Metrics
(Doc ID 2724352.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- A query on view DBA_HIST_SYSMETRIC_HISTORY does not show all metrics shown in V$SYSMETRIC_HISTORY:
SQL> select count(0), METRIC_NAME from DBA_HIST_SYSMETRIC_HISTORY group by METRIC_NAME order by 1;
23 rows selected.
SQL> select count(0), METRIC_NAME from V$SYSMETRIC_HISTORY group by METRIC_NAME order by 1;
161 rows selected.
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 |