2.153 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 |
|---|---|---|---|
|
|
|
|
Table owner |
|
|
|
|
Name of the object |
|
|
|
|
Name of the sub-object |
|
|
|
|
Latest timestamp on which the segment has write access |
|
|
|
|
Latest timestamp on which the segment has read access |
|
|
|
|
Latest timestamp on which the segment has full table scan |
|
|
|
|
Latest timestamp on which the segment has index scan |
See Also: