ilm
This is an old revision of the document!
Table of Contents
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
ADO policies can be set at segment, row or tablespace level.
ilm.1454951297.txt.gz · Last modified: 2025/03/08 22:23 (external edit)