Overview
cpu_count specifies the total number of CPU cores in the system.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Only the
systenant can modify this parameter; user tenants cannot modify it.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 0: The system automatically detects the number of CPUs. |
| Value range | [0, +∞) |
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
Other configurations in the cluster may affect how this parameter takes effect. After configuring this parameter, we recommend that you use the SELECT statement to view the actual effective value of the CPU_CAPACITY field in the internal GV$OB_SERVERS table. If it does not take effect dynamically, you need to restart the entire cluster.
Configuration example
Set the total number of system CPUs to 16.
obclient> ALTER SYSTEM SET cpu_count=16;
References
- Set the maximum CPU quota for the system: server_cpu_quota_max
- Set the minimum quota for system CPU: server_cpu_quota_min