1.133 HEAT_MAP

Use HEAT_MAP to enable or disable both the Heat Map and Automatic Data Optimization (ADO) features.

Property Description

Parameter type

String

Syntax

HEAT_MAP = { ON | OFF }

Default value

OFF

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

If specified, use the same value on all instances

Setting the HEAT_MAP initialization parameter to ON causes the database to track read and write access of all segments, as well as modification of database blocks, due to DMLs and DDLs. The activities are not tracked for objects in SYSTEM and SYSAUX tablespaces.

See Also: