Purpose
The USER_TAB_STATISTICS view displays the optimizer statistics of all tables owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
References
ALL_TAB_STATISTICS
DBA_TAB_STATISTICS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| PARTITION_POSITION | NUMBER | NO | The position of the partition within the table. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition. |
| SUBPARTITION_POSITION | NUMBER | NO | The position of the subpartition in the partition. |
| OBJECT_TYPE | VARCHAR2(12) | NO | The type of the object. |
| NUM_ROWS | NUMBER | YES | The number of rows in the object. |
| BLOCKS | NUMBER | YES | The value is NULL. |
| EMPTY_BLOCKS | NUMBER | YES | The value is NULL. |
| AVG_SPACE | NUMBER | YES | The value is NULL. |
| CHAIN_CNT | NUMBER | YES | The value is NULL. |
| AVG_ROW_LEN | NUMBER | YES | The average row length of the object. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | YES | The value is NULL. |
| NUM_FREELIST_BLOCKS | NUMBER | YES | The value is NULL. |
| AVG_CACHED_BLOCKS | NUMBER | YES | The value is NULL. |
| AVG_CACHE_HIT_RATIO | NUMBER | YES | The value is NULL. |
| IM_IMCU_COUNT | NUMBER | YES | The value is NULL. |
| IM_BLOCK_COUNT | NUMBER | YES | The value is NULL. |
| IM_STAT_UPDATE_TIME | TIMESTAMP(9) | YES | The value is NULL. |
| SCAN_RATE | NUMBER | YES | The value is NULL. |
| SAMPLE_SIZE | NUMBER | YES | The sample size when statistics are collected. |
| LAST_ANALYZED | DATE | YES | The date when the object was analyzed the last time. |
| GLOBAL_STATS | VARCHAR2(3) | YES | YES: indicates that the statistics are directly collected or incrementally maintained.NO: other cases. |
| USER_STATS | VARCHAR2(3) | YES | Indicates whether the partition statistics are set by the user. |
| STATTYPE_LOCKED | VARCHAR2(5) | YES | The statistics lock type. |
| STALE_STATS | VARCHAR2(3) | YES | Indicates whether the statistics are stale. |
| SCOPE | VARCHAR2(7) | YES | The effective scope of the statistics. |