My Oracle Support Banner

Parameter for heat_map is Enabled but no Data is Showing Up in Related Views/tables (Doc ID 2975672.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Oracle HEAT MAP was enabled in a database but no data is showing up in system views/tables, even after making some modifications to test tables.

-  There was no details seen in the heat map related tables even after re-start of the database.

-  As suggested in Doc ID 2930481.1, attempting to flush the data manually also did not help:

exec dbms_ilm.flush_all_segments;

-  Same set of steps worked in another database of same version.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.