DBA_HEATMAP_TOP_OBJECTS

DBA_HEATMAP_TOP_OBJECTS displays heat map information for the top 10000 objects by default. If the database contains fewer than 10000 objects, then fewer than 10000 objects are returned by the view.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Object owner
`OBJECT_NAME`	`VARCHAR2(128)`	Object name
`OBJECT_TYPE`	`VARCHAR2(18)`	Object type
`TABLESPACE_NAME`	`VARCHAR2(30)`	Tablespace name
`SEGMENT_COUNT`	`NUMBER`	Segments in the tablespace
`OBJECT_SIZE`	`NUMBER`	Size of the object in MB
`MIN_WRITETIME`	`DATE`	Minimum write time of the object
`MAX_WRITETIME`	`DATE`	Maximum write time of the object
`AVG_WRITETIME`	`DATE`	Average write time of the object
`MIN_READTIME`	`DATE`	Minimum read time of the object
`MAX_READTIME`	`DATE`	Maximum read time of the object
`AVG_READTIME`	`DATE`	Average read time of the object
`MIN_FTSTIME`	`DATE`	Minimum full table scan time of the object
`MAX_FTSTIME`	`DATE`	Maximum full table scan time of the object
`AVG_FTSTIME`	`DATE`	Average full table scan time of the object
`MIN_LOOKUPTIME`	`DATE`	Minimum lookup time of the object
`MAX_LOOKUPTIME`	`DATE`	Maximum lookup time of the object
`AVG_LOOKUPTIME`	`DATE`	Average lookup time of the object