2.152 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_HISTOGRAM displays segment access information for all segments.

• USER_HEAT_MAP_SEG_HISTOGRAM displays segment access information for 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
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:

• "DBA_HEAT_MAP_SEG_HISTOGRAM"

• "USER_HEAT_MAP_SEG_HISTOGRAM"