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 |
---|---|---|---|
|
|
|
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: