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
`N_FULL_SCAN`	`NUMBER`	Number of table scans
`N_LOOKUP_SCAN`	`NUMBER`	Number of lookup scans
`N_FASTFULLINDEX_SCAN`	`NUMBER`	Number of fast full index scans
`N_RANGEINDEX_SCAN`	`NUMBER`	Number of range index scans
`N_DML_SCAN`	`NUMBER`	Number of scans originating from DMLs
`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

See Also: “ALL_HEAT_MAP_SEGMENT”