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 | NULL | 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 |