Incorrect Data IN V$HEAT_MAP related views
(Doc ID 2902769.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Incorrect data shown for v$heat_map_segment and dba_heatmap_top_objects views.
SQL> select inst_id,name,value from gv$parameter where name like '%heat%';
INST_ID NAME VALUE
---------- -------------------- --------------------
1 heat_map ON
2 heat_map ON
3 heat_map ON
SQL> select count(*) from V$HEAT_MAP_SEGMENT;
COUNT(*)
----------
0
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 |
| References |