Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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: