Note
This parameter is introduced in OceanBase Database V2.2.50.
Description
px_workers_per_cpu_quota specifies the number of parallel execution threads that can be allocated per CPU.
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 |
|---|---|
| Parameter type | Int |
| Default value | 10 |
| Value range | [0, 20] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective only after OBServer restart | This parameter takes effect immediately after the setting. |
Examples
Set the number of parallel execution threads that can be allocated per CPU to 10.
obclient> ALTER SYSTEM SET px_workers_per_cpu_quota =10;