4.285 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 |
|---|---|---|---|
|
|
|
|
Object owner |
|
|
|
|
Object name |
|
|
|
|
Object type |
|
|
|
|
Tablespace name |
|
|
|
|
Segments in the tablespace |
|
|
|
|
Size of the object in MB |
|
|
|
|
Oldest modification time for a set of blocks |
|
|
|
|
Latest modification time for a set of blocks |
|
|
|
|
Average of the modification times for a set of blocks |
|
|
|
|
Oldest read time for a set of blocks |
|
|
|
|
Latest read time for a set of blocks |
|
|
|
|
Average of the read times for a set of blocks |
|
|
|
|
Minimum full table scan time of the object |
|
|
|
|
Maximum full table scan time of the object |
|
|
|
|
Average full table scan time of the object |
|
|
|
|
Minimum lookup time of the object |
|
|
|
|
Maximum lookup time of the object |
|
|
|
|
Average lookup time of the object |