server_cpu_quota_max

Description

server_cpu_quota_max specifies the maximum CPU quota available to the system.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can query this parameter by using the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view.

• Modify the parameter

  Only the sys tenant can modify this parameter. User tenants cannot modify this parameter.

Attributes

Considerations

When the value is 0, the system adaptively adjusts the maximum CPU quota based on the cpu_count value of the server:

1. If cpu_count is less than 8, the server_cpu_quota_max value is adaptively adjusted to 1.
2. If 8 ≤ cpu_count < 16, the server_cpu_quota_max value is adaptively adjusted to 2.
3. If 16 ≤ cpu_count < 32, the server_cpu_quota_max value is adaptively adjusted to 3.
4. If cpu_count is 32 or more, the server_cpu_quota_max value is adaptively adjusted to 4.

Examples

Adaptively adjust the maximum CPU quota.

obclient> ALTER SYSTEM SET server_cpu_quota_max=0;