Note
This parameter is available starting with V4.0.0.
Description
log_disk_utilization_threshold specifies the threshold of the log disk utilization for a tenant. When the log disk usage of a tenant exceeds the total log disk space of the tenant multiplied by this value, the system reuses log files.
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
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 80 |
| Value range | [10, 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
The value of log_disk_utilization_threshold must be less than that of log_disk_utilization_limit_threshold.
Examples
Set the log disk utilization threshold of a tenant to 80.
obclient> ALTER SYSTEM SET log_disk_utilization_threshold=80;
References
For more information about logs, see Redo logs.