ALL_HEAT_MAP_SEG_HISTOGRAM
ALL_HEAT_MAP_SEG_HISTOGRAM displays segment access information for all segments visible to the user.
Related Views
-
DBA_HEAT_MAP_SEG_HISTOGRAMdisplays segment access information for all segments. -
USER_HEAT_MAP_SEG_HISTOGRAMdisplays segment access information for 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 | |
TRACK_TIME |
DATE |
System time when the segment access was tracked | |
SEGMENT_WRITE |
VARCHAR2(3) |
Indicates whether the segment has write access (YES or NO) |
|
FULL_SCAN |
VARCHAR2(3) |
Indicates whether the segment has full table scan (YES or NO) |
|
LOOKUP_SCAN |
VARCHAR2(3) |
Indicates whether the segment has lookup scan (YES or NO) |
See Also: