Purpose
The ALL_TAB_STATISTICS view displays the optimizer statistics of tables accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_TAB_STATISTICS
USER_TAB_STATISTICS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| 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 column 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. |
