To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification.
Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level. You can enable this functionality with the HEAT_MAP initialization parameter.
This section contains the following topics:
Enabling and Disabling Heat Map
Displaying Heat Map Tracking Data With Views
Managing Heat Map Data With DBMS_HEAT_MAP Subprograms
Scripting on this page enhances content navigation, but does not change the content in any way.