DBA_HEATMAP_TOP

4.327 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`	Oldest modification time for a set of blocks
`MAX_WRITETIME`	`DATE`	Latest modification time for a set of blocks
`AVG_WRITETIME`	`DATE`	Average of the modification times for a set of blocks
`MIN_READTIME`	`DATE`	Oldest read time for a set of blocks
`MAX_READTIME`	`DATE`	Latest read time for a set of blocks
`AVG_READTIME`	`DATE`	Average of the read times for a set of blocks
`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