My Oracle Support Banner

Heat Map Is Enabled But Views Show No Data (Doc ID 2903436.1)

Last updated on NOVEMBER 04, 2022

Applies to:

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

Goal

Customer followed this document to enable heat map: https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/ilm-strategy-heatmap-ado.html#GUID-1E510486-2ED8-467A-A5BA-045F4F3AC324

Heat map is enabled but related DB views show no data:

SQL> 2 SQL> select name, value from v$system_parameter where name IN ('heat_map', '_enable_heatmap_internal')
  2 /

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
heat_map
ON


2.SQL> select distinct(tablespace_name) from DBA_HEATMAP_TOP_TABLESPACES order by tablespace_name;

no rows selected

 

Solution

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
Goal
Solution


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