Note
For V1.4, this parameter is available starting with V1.4.
Description
datafile_disk_percentage specifies the percentage of the total disk space occupied by data files ( data_dir is initialized for OceanBase Database to store data).
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 0
NoteFor V4.0.0, the default value is adjusted from 90 to 0. |
| Value range | [0, 99]
NoteFor V4.0.0, the value range is adjusted from [5, 99] to [0, 99]. |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
When this parameter and
datafile_sizeare configured at the same time, the value of datafile_size is used.When this parameter is set to 0, the system automatically calculates the percentage of the total disk space occupied by data files based on whether logs and data share the same disk:
- If they share the same disk, the percentage is 60%.
- If they do not share the same disk, the percentage is 90%.
Examples
Set the percentage of the total disk space occupied by data files to 98.
obclient> ALTER SYSTEM SET datafile_disk_percentage = 98;