DBA_TAB_STATS_HISTORY

2023-12-08 07:13:36  Updated

Purpose

The DBA_TAB_STATS_HISTORY view displays the change history of the table statistics of all tables in the database.

Note

This view is introduced since OceanBase Database V3.2.1.

  • ALL_TAB_STATS_HISTORY

  • USER_TAB_STATS_HISTORY

Columns

Column Type Nullable? Description
OWNER VARCHAR2(128) NO The owner of the table.
TABLE_NAME VARCHAR2(128) NO The name of the table.
PARTITION_NAME VARCHAR2(128) YES The name of the partition.
SUBPARTITION_NAME VARCHAR2(128) YES The name of the subpartition.
STATS_UPDATE_TIME TIMESTAMP(6) WITH TIME ZONE YES The time when the statistics were updated.

Contact Us