Note
- OceanBase Database V4.x implements a new statistics collection mechanism which does not collect statistics during major compactions. This parameter has been deprecated since OceanBase Database V4.0.0.
- In OceanBase Database V4.x, you can call the
DBMS_STATSsystem package to collect statistics. For more information, see Overview.
Description
merge_stat_sampling_ratio specifies the sampling rate of data column statistics in a major compaction.
Attributes
Attribute |
Description |
|---|---|
| Type | Integer |
| Default value | 100 |
| Value range | [0, 100] |
| Effective upon OBServer node restart | No |