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_SEGMENTdisplays the latest segment access time for all segments. -
USER_HEAT_MAP_SEGMENTdisplays the latest segment access time for all segments owned by the user. This view does not display theOWNERcolumn.
| 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 |
See Also: