2.155 ALL_HEAT_MAP_SEGMENT

ALL_HEAT_MAP_SEGMENT displays the latest segment access time for all segments visible to the user. The timestamps in the view are coarse with a granularity of a day reflecting the flush times of the heat map.

Related Views

  • DBA_HEAT_MAP_SEGMENT displays the latest segment access time for all segments.

  • USER_HEAT_MAP_SEGMENT displays the latest segment access time for all segments owned by the user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Table owner

OBJECT_NAME

VARCHAR2(128)

NOT NULL

Name of the object

SUBOBJECT_NAME

VARCHAR2(128)

Name of the sub-object

SEGMENT_WRITE_TIME

DATE

Latest timestamp on which the segment has write access

SEGMENT_READ_TIME

DATE

Latest timestamp on which the segment has read access

FULL_SCAN

DATE

Latest timestamp on which the segment has full table scan

LOOKUP_SCAN

DATE

Latest timestamp on which the segment has index scan