User Tools

Site Tools


ilm

This is an old revision of the document!


Information Lifecycle Management

Heat Map

By default the Heat Map initialisation parameter is set to OFF.
It can be changed at the session and system level.

 ALTER SYSTEM SET HEAT_MAP = ON;

Causes the database to track read and write access of all segments.
The activities are not tracked for objects in SYSTEM and SYSAUX tablespaces.

Views

V$HEAT_MAP_SEGMENT
DBA_HEAT_MAP_SEGMENT
DBA_HEAT_MAP_TOP_OBJECTS
DBA_HEAT_MAP_TOP_TABLESPACES

Automatic Data Optimisation

ilm.1454950065.txt.gz · Last modified: 2025/03/08 22:23 (external edit)