4.280 DBA_HEATMAP_TOP_TABLESPACES

DBA_HEATMAP_TOP_TABLESPACES displays heat map information for the top 100 tablespaces.

Column Datatype NULL Description

TABLESPACE_NAME

VARCHAR2(128)

Tablespace name

SEGMENT_COUNT

NUMBER

Segments in the tablespace

ALLOCATED_BYTES

NUMBER

Total bytes allocated to the objects in the tablespace

MIN_WRITETIME

DATE

Minimum write time of objects tracked

MAX_WRITETIME

DATE

Maximum write time of objects tracked

AVG_WRITETIME

DATE

Average write time of objects tracked

MIN_READTIME

DATE

Minimum read time of objects tracked

MAX_READTIME

DATE

Maximum read time of objects tracked

AVG_READTIME

DATE

Average read time of objects tracked

MIN_FTSTIME

DATE

Minimum full table scan time of objects tracked

MAX_FTSTIME

DATE

Maximum full table scan time of objects tracked

AVG_FTSTIME

DATE

Average full table scan time of objects tracked

MIN_LOOKUPTIME

DATE

Minimum lookup time of objects tracked

MAX_LOOKUPTIME

DATE

Maximum lookup time of objects tracked

AVG_LOOKUPTIME

DATE

Average lookup time of objects tracked