Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_HEATMAP_TOP_OBJECTS

DBA_HEATMAP_TOP_OBJECTS displays heat map information for the top 1000 objects.

Column Datatype NULL Description
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