server_cpu_quota_max

Description

server_cpu_quota_max specifies the maximum CPU quota that can be used by the system.

Privilege requirements

• Query the parameter

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

• 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 automatically adjusts the maximum CPU quota based on the cpu_count of the server:

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

Examples

Set the maximum CPU quota to be automatically adjusted.

obclient> ALTER SYSTEM SET server_cpu_quota_max=0;