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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Oracle HEAT MAP was enabled in a 12.1.0.2 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.

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


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