ORA-38342: heat map not enabled

brunors

I have had the brilliant idea to perform a test to be able to track the modification of database blocks, read and write access in segments made by DMLs and DDLS in one of my databases.
I knew already that to do this I had just to enable the parameter heat_map from OFF to ON. So I did :


SQL> show parameter heat_map
NAME                     TYPE    VALUE
heat_map                 string  OFF

SQL> alter system set heat_map='ON' scope=both;

System altered.

SQL> show  parameters heat_map

NAME                     TYPE    VALUE
heat_map                 string  ON

Well, I have done what I thought. Now let’s create a table to check my enabled parameter:


SQL> CREATE TABLE VENDAS_ADO
(PRODUTO NUMBER NOT NULL,
CLIENTE_COD NUMBER NOT NULL,
TEMP_DATA DATE NOT NULL,
COMM NUMBER NOT NULL,
DESCONTO NUMBER NOT NULL,
QTDE_VEND NUMBER(10,2) NOT NULL,
NUMERO_VENDAS NUMBER(10,2) NOT NULL )
PARTITION BY RANGE (TEMP_DATA)
( PARTITION VENDAS_QUAR1_2019 VALUES LESS THAN (TO_DATE('01-APR-2019','dd-MON-yyyy')),
PARTITION VENDAS_QUAR2_2019 VALUES LESS THAN (TO_DATE('01-JUL-2019','dd-MON-yyyy')),
PARTITION VENDAS_QUAR3_2019 VALUES LESS THAN (TO_DATE('01-OCT-2019','dd-MON-yyyy')),
PARTITION VENDAS_QUAR4_2019 VALUES LESS THAN (TO_DATE('01-JAN-2013','dd-MON-yyyy')) )
ILM ADD POLICY COMPRESS FOR ARCHIVE HIGH SEGMENT
AFTER 12 MONTHS OF NO ACCESS;  2    3    4    5    6    7    8    9   10   11   12   13   14   15
CREATE TABLE VENDAS_ADO
*
ERROR at line 1:
ORA-38342: heat map not enabled

What? What happened? Am I crazy? I am 100% sure that I have the heat_map parameter enabled. So let’s check again:


SQL> show  parameters heat_map

NAME                     TYPE    VALUE
heat_map                 string  ON

After take a look at Oracle documentation I figured out the reason for my case and here they are :

ADO and Heat Map are not supported with a multitenant container database (CDB).”. So “YESSSS!”, I have a CDB and it’s not supported by ADO and HEAP Map with this option.

SQL>
SQL> select cdb from v$database;
CDB
YES

Related posts

Leave a Comment