Note
This parameter was introduced in V4.2.0 and is a tenant-level parameter.
Description
The balancer_idle_time parameter specifies the interval for waking up idle threads for load balancing and other background tasks.
- In the system tenant: specifies the interval for waking up disaster recovery threads and balancing threads.
- In a user tenant: specifies the interval for waking up log stream balancing threads.
Privilege requirements
Query the parameter
The
systenant and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 10s, which indicates 10 seconds.
NoteThe default value of this parameter was changed from 5m to 10s in V4.2.0. |
| Value range | [10s, +∞) |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| Requires a system restart to take effect | No |
Examples
Set the interval for waking up disaster recovery threads and balancing threads to 10 seconds for all tenants in the SYS tenant.
obclient> ALTER SYSTEM SET balancer_idle_time = '10s' tenant = ALL;Set the interval for waking up disaster recovery threads and balancing threads to 10 minutes for the tenant1 tenant in the SYS tenant.
obclient> ALTER SYSTEM SET balancer_idle_time = '10m' tenant = 'tenant1';Set the interval for waking up disaster recovery threads and balancing threads to 10 minutes in a user tenant.
obclient> ALTER SYSTEM SET balancer_idle_time = '10m';