[Home] [Help] [Dependency Information]
Object Name: | DBA_HEATMAP_TOP_TABLESPACES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Heatmap for Top N tablespaces
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 |
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;
|
|
|