DBA_HEATMAP_TOP_TABLESPACES displays heat map information for the top 100 tablespaces.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Tablespace name |
|
|
|
|
Segments in the tablespace |
|
|
|
|
Total bytes allocated to the objects in the tablespace |
|
|
|
|
Minimum write time of objects tracked |
|
|
|
|
Maximum write time of objects tracked |
|
|
|
|
Average write time of objects tracked |
|
|
|
|
Minimum read time of objects tracked |
|
|
|
|
Maximum read time of objects tracked |
|
|
|
|
Average read time of objects tracked |
|
|
|
|
Minimum full table scan time of objects tracked |
|
|
|
|
Maximum full table scan time of objects tracked |
|
|
|
|
Average full table scan time of objects tracked |
|
|
|
|
Minimum lookup time of objects tracked |
|
|
|
|
Maximum lookup time of objects tracked |
|
|
|
|
Average lookup time of objects tracked |