datafile_next specifies the step size of automatic scaling for disk files.
Note
This parameter was introduced in OceanBase Database V3.1.5.
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 0 |
| Value range | [0M, +∞) |
| Effective upon OBServer node restart | No |
The default value of the datafile_next parameter is 0, which indicates that automatic scaling is disabled. To enable automatic scaling, you need to set the parameter to another value based on the following rules:
- If you set the
datafile_nextparameter to a value less than 1 GB, the following value is used: min(1G,datafile_maxsize×10%). - If you set the
datafile_nextparameter to a value greater than 1 GB, the following value is used: min(datafile_next,Remaining disk space).
Example
alter system set datafile_next = '10G';