The OceanBase Database optimizer supports manual and automatic collection of statistics. It also provides views compatible with Oracle databases to help you query the collected statistics in Oracle mode.
The following table describes the views for querying the collected statistics in Oracle mode.
| View | Description |
|---|---|
| ALL_TAB_STATISTICS DBA_TAB_STATISTICS USER_TAB_STATISTICS | Displays table-level statistics. |
| ALL_TAB_COL_STATISTICS DBA_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS | Displays global-level column statistics. |
| ALL_PART_COL_STATISTICS DBA_PART_COL_STATISTICS USER_PART_COL_STATISTICS | Displays partition-level column statistics. |
| ALL_SUBPART_COL_STATISTICS DBA_SUBPART_COL_STATISTICS USER_SUBPART_COL_STATISTICS | Displays subpartition-level column statistics. |
| ALL_TAB_HISTOGRAMS DBA_TAB_HISTOGRAMS USER_TAB_HISTOGRAMS | Displays global-level column histogram statistics. |
| ALL_PART_HISTOGRAMS DBA_PART_HISTOGRAMS USER_PART_HISTOGRAMS | Displays partition-level column histogram statistics. |
| ALL_SUBPART_HISTOGRAMS DBA_SUBPART_HISTOGRAMS USER_SUBPART_HISTOGRAMS | Displays subpartition-level column histogram statistics. |
| SYS.ALL_VIRTUAL_TABLE_STAT_V2_REAL_AGENT | Displays table-level statistics. It is a virtual table. |
| SYS.ALL_VIRTUAL_COLUMN_STAT_V2_REAL_AGENT | Displays column-level basic statistics. It is a virtual table. |
| SYS.ALL_VIRTUAL_HISTOGRAM_STAT_V2_REAL_AGENT | Displays column-level histogram information. It is a virtual table. |