V$HEAT_MAP_SEGMENT

7.256 V$HEAT_MAP_SEGMENT

V$HEAT_MAP_SEGMENT displays real-time segment access information.

Column	Datatype	Description
`OBJECT_NAME`	`VARCHAR2(128)`	Name of the object
`SUBOBJECT_NAME`	`VARCHAR2(128)`	Name of the subobject
`OBJ#`	`NUMBER`	Object number
`DATAOBJ#`	`NUMBER`	Data object number
`TS#`	`NUMBER`	ID of the tablespace containing the segment whose heat map is tracked
`TRACK_TIME`	`DATE`	Timestamp of current activity tracking
`SEGMENT_WRITE`	`VARCHAR2(3)`	Indicates whether the segment has write access: (`YES` or `NO`)
`SEGMENT_READ`	`VARCHAR2(3)`	Indicates whether the segment has read 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`)
`N_SEGMENT_WRITE`	`NUMBER`	Number of segment writes This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`N_FULL_SCAN`	`NUMBER`	Number of table scans This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`N_LOOKUP_SCAN`	`NUMBER`	Number of lookup scans This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data