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_SEGMENT

ALL_HEAT_MAP_SEGMENT displays the latest segment access time 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
SEGMENT_WRITE_TIME DATE   Latest timestamp on which the segment has write access
SEGMENT_READ_TIME DATE   Latest timestamp on which the segment has read access
FULL_SCAN DATE   Latest timestamp on which the segment has full table scan
LOOKUP_SCAN DATE   Latest timestamp on which the segment has index scan