Purpose
The USER_TAB_STATS_HISTORY view displays the statistics change history of all tables owned by the current user.
Note
This view is introduced since OceanBase Database V3.2.1.
Related views
ALL_TAB_STATS_HISTORYDBA_TAB_STATS_HISTORY
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| 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. |