Description
DBA_TAB_STATISTICS displays the optimizer statistics of all tables in the database.
Related views
ALL_TAB_STATISTICS
USER_TAB_STATISTICS
Fields
| Field | 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 in 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 | NO | The number of rows in the object. |
| BLOCKS | NUMBER | NO | The value is NULL. |
| EMPTY_BLOCKS | NUMBER | NO | The value is NULL. |
| AVG_SPACE | NUMBER | NO | The value is NULL. |
| CHAIN_CNT | NUMBER | NO | The value is NULL. |
| AVG_ROW_LEN | NUMBER | NO | The average row length of the object. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | The value is NULL. |
| NUM_FREELIST_BLOCKS | NUMBER | NO | The value is NULL. |
| AVG_CACHED_BLOCKS | NUMBER | NO | The value is NULL. |
| AVG_CACHE_HIT_RATIO | NUMBER | NO | The value is NULL. |
| IM_IMCU_COUNT | NUMBER | NO | The value is NULL. |
| IM_BLOCK_COUNT | NUMBER | NO | The value is NULL. |
| IM_STAT_UPDATE_TIME | TIMESTAMP(9) | NO | The value is NULL. |
| SCAN_RATE | NUMBER | NO | The value is NULL. |
| SAMPLE_SIZE | NUMBER | NO | The sample size when statistics are collected. |
| LAST_ANALYZED | DATE | NO | The date when the column was analyzed the last time. |
| GLOBAL_STATS | VARCHAR2(3) | NO | YES: indicates that the statistics are directly collected or incrementally maintained.NO: other cases. |
| USER_STATS | VARCHAR2(3) | NO | Indicates whether the partition statistics are set by the user. |
| STATTYPE_LOCKED | VARCHAR2(5) | NO | The statistics lock type. |
| STALE_STATS | VARCHAR2(3) | NO | Indicates whether the statistics are stale. |
| SCOPE | VARCHAR2(7) | NO | The effective scope of the statistics. |