HEAT_MAP


Property Description

Parameter type

String

Syntax

HEAT_MAP = { ON | OFF }

Default value

OFF

Modifiable

ALTER SESSION, ALTER SYSTEM

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.

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

See Also: