Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_HEAT_MAP_SEG_HISTOGRAM

ALL_HEAT_MAP_SEG_HISTOGRAM displays segment access information for all segments visible to the user.

Related Views

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)