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

VIEW: SYS.DBA_HEATMAP_TOP_OBJECTS

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

Heatmap for Top N objects

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

SYS.DBA_HEATMAP_TOP_OBJECTS references the following:

SchemaSYS
TableWRI$_HEATMAP_TOP_OBJECTS
SYS.DBA_HEATMAP_TOP_OBJECTS is referenced by following:

SchemaPUBLIC
SynonymDBA_HEATMAP_TOP_OBJECTS