[Home] [Help] [Dependency Information]
Object Name: | DBA_HEATMAP_TOP_OBJECTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Heatmap for Top N objects
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Object Owner | |
OBJECT_NAME | VARCHAR2 | (128) | Object Name | |
OBJECT_TYPE | VARCHAR2 | (18) | Object type | |
TABLESPACE_NAME | VARCHAR2 | (30) | Tablespace name | |
SEGMENT_COUNT | NUMBER | Segments in the tablespace | ||
OBJECT_SIZE | NUMBER | Size of the object in MB | ||
MIN_WRITETIME | DATE | Minimum write time of the object | ||
MAX_WRITETIME | DATE | Maximum write time of the object | ||
AVG_WRITETIME | DATE | Average write time of the object | ||
MIN_READTIME | DATE | Minimum read time of the object | ||
MAX_READTIME | DATE | Maximum read time of the object | ||
AVG_READTIME | DATE | Average read time of the object | ||
MIN_FTSTIME | DATE | Minimum full table scan time of the object | ||
MAX_FTSTIME | DATE | Maximum full table scan time of the object | ||
AVG_FTSTIME | DATE | Average full table scan time of the object | ||
MIN_LOOKUPTIME | DATE | Minimum lookup time of the object | ||
MAX_LOOKUPTIME | DATE | Maximum lookup time of the object | ||
AVG_LOOKUPTIME | DATE | Average lookup time of the object |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, OBJECT_NAME
, OBJECT_TYPE
, TABLESPACE_NAME
, SEGMENT_COUNT
, OBJECT_SIZE
, 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_OBJECTS;
|
|
|