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.
Related views
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. |