Purpose
The oceanbase.DBA_TAB_STATISTICS view displays the optimizer statistics of all tables of the database.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | varchar(128) | NO | The owner of the object. |
| TABLE_NAME | varchar(128) | NO | The name of the table. |
| PARTITION_NAME | varchar(128) | NO | The name of the partition. |
| PARTITION_POSITION | decimal(10,0) | NO | The position of the partition within the table. |
| SUBPARTITION_NAME | varchar(128) | NO | The name of the subpartition. |
| SUBPARTITION_POSITION | decimal(10,0) | NO | The position of the subpartition in the partition. |
| OBJECT_TYPE | varchar(12) | NO | The type of the object. Valid values: |
| NUM_ROWS | decimal(10,0) | NO | The number of rows in the object. |
| BLOCKS | decimal(10,0) | NO | The number of blocks used in the object. |
| EMPTY_BLOCKS | decimal(10,0) | NO | The number of empty blocks in the object. |
| AVG_SPACE | decimal(10,0) | NO | The average available space in the object. |
| CHAIN_CNT | decimal(10,0) | NO | The number of linked rows in the object. |
| AVG_ROW_LEN | decimal(10,0) | NO | The average row length, including the row overhead. |
| AVG_SPACE_FREELIST_BLOCKS | decimal(10,0) | NO | The average free space of all blocks on FREELIST. |
| NUM_FREELIST_BLOCKS | decimal(10,0) | NO | The number of blocks on FREELIST. |
| AVG_CACHED_BLOCKS | decimal(10,0) | NO | The average number of blocks in the buffer cache. |
| AVG_CACHE_HIT_RATIO | decimal(10,0) | NO | The average cache hit rate of the object. |
| IM_IMCU_COUNT | decimal(10,0) | NO | The number of in-memory compression units (IMCUs) in the table. |
| IM_BLOCK_COUNT | decimal(10,0) | NO | The number of in-memory blocks in the table. |
| IM_STAT_UPDATE_TIME | datetime | NO | The timestamp of the most recent update of statistics in the memory. |
| SCAN_RATE | decimal(10,0) | NO | The scan rate of the object, in MB/s. |
| SAMPLE_SIZE | decimal(10,0) | NO | The sample size used to analyze the table. |
| LAST_ANALYZED | datetime(6) | NO | The date when the table was analyzed the last time. |
| GLOBAL_STATS | varchar(3) | NO | Indicates whether the statistics are collected or incrementally maintained. Valid values: |
| USER_STATS | varchar(3) | NO | Indicates whether the statistics are directly entered by the user. Valid values: |
| STATTYPE_LOCKED | varchar(5) | NO | The type of the statistics lock. Valid values: |
| STALE_STATS | varchar(3) | NO | The additional properties that describe the statistics. For example, STATS_ON_CONVENTIONAL_LOAD indicates that the statistics are obtained through online statistics collection with regular DML. |
| SCOPE | varchar(7) | NO | The value SHARED indicates statistics are collected from any table other than global temporary tables. For global temporary tables, the value can be: SESSION: indicates that the statistics are session-specific.SHARED: indicates that statistics are shared across all sessions. |