4.137 ALL_TAB_STATS_HISTORY

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

Related Views

  • DBA_TAB_STATS_HISTORY provides a history of table statistics modifications for all tables in the database.

  • USER_TAB_STATS_HISTORY provides a history of table statistics modifications for all tables owned by 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: