DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_HEATMAP_TOP_TABLESPACES

Object Details
Object Name: DBA_HEATMAP_TOP_TABLESPACES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Heatmap for Top N tablespaces

[View Source]

Columns
Name Datatype Length Mandatory Comments
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TABLESPACE_NAME
,      SEGMENT_COUNT
,      ALLOCATED_BYTES
,      MIN_WRITETIME
,      MAX_WRITETIME
,      AVG_WRITETIME
,      MIN_READTIME
,      MAX_READTIME
,      AVG_READTIME
,      MIN_FTSTIME
,      MAX_FTSTIME
,      AVG_FTSTIME
,      MIN_LOOKUPTIME
,      MAX_LOOKUPTIME
,      AVG_LOOKUPTIME
FROM SYS.DBA_HEATMAP_TOP_TABLESPACES;

Dependencies

[top of page]

SYS.DBA_HEATMAP_TOP_TABLESPACES references the following:

SchemaSYS
TableWRI$_HEATMAP_TOP_TABLESPACES
SYS.DBA_HEATMAP_TOP_TABLESPACES is referenced by following:

SchemaPUBLIC
SynonymDBA_HEATMAP_TOP_TABLESPACES