Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
|
Modifiable |
|
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:
Oracle Database VLDB and Partitioning Guide for more information about enabling and disabling the Heat Map feature
Oracle Database VLDB and Partitioning Guide for more information about Heat Map tracking