ALL_TAB_STATS_HISTORY

ALL_TAB_STATS_HISTORY provides a history of table statistics modifications for all tables accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the object
TABLE_NAME VARCHAR2(128)   Name of the table
PARTITION_NAME VARCHAR2(128)   Name of the partition
SUBPARTITION_NAME VARCHAR2(128)   Name of the subpartition
STATS_UPDATE_TIME TIMESTAMP(6) WITH TIME ZONE   Time at which the statistics were updated
NUM_ROWSFoot 1 NUMBER   Number of rows in the object
BLOCKSFoot 1 NUMBER   Number of used blocks in the object
CHAIN_CNTFoot 1 NUMBER   Average row length, including row overhead
AVG_ROW_LENFoot 1 NUMBER   Number of chained rows in the object
AVG_CACHED_BLOCKSFoot 1 NUMBER   Average number of blocks in the buffer cache
AVG_CACHE_HIT_RATIOFoot 1 NUMBER   Average cache hit ratio for the object
IM_IMCU_COUNTFoot 1 NUMBER   Number of In-Memory Compression Units (IMCUs) in the table
IM_BLOCK_COUNTFoot 1 NUMBER   Number of In-memory blocks in the table
SCAN_RATEFoot 1 NUMBER   Scan rate for the object in megabytes per second. This statistic is only relevant or meaningful for external tables.
SAMPLE_SIZEFoot 1 NUMBER   Sample size used in analyzing the table

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.2.

See Also: