For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.

Purpose

This package provides heatmap information at block/extent/segment object and tablespace levels. It contains the definitions for processing heatmap for top N objects and tablespaces.

The execution privilege is granted to PUBLIC. Procedures in this package run under the caller security. The user must have ANALYZE privilege on the object.

Returns the extent level ILM statistics for a table segment. It returns no information for segment types that are not data. Aggregates at extent level including minimum modification time and maximum modification time are returned.

dbms_heat_map.segment_heat_map(
tablespace_id IN NUMBER,
header_file IN NUMBER,
header_block IN NUMBER,
segment_objd IN NUMBER,
min_writetime OUT DATE,
max_writetime OUT DATE,
avg_writetime OUT DATE,
min_readtime OUT DATE,
max_readtime OUT DATE,
avg_readtime OUT DATE,
min_ftstime OUT DATE,
max_ftstime OUT DATE,
avg_ftstime OUT DATE,
min_lookuptime OUT DATE,
max_lookuptime OUT DATE,
avg_lookuptime OUT DATE);