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
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.