Note
This parameter was introduced in V4.2.1.
Description
The ddl_thread_score parameter specifies the number of threads to be used for DDL tasks.
Permissions
Query the parameter
Tenants with the
sysprivilege and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview for this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | Int |
| Default value | 0, which indicates 2 as the default number of threads |
| Value range | [0, 100] |
| Modifiability | Yes. You can execute the ALTER SYSTEM SET statement to modify it. |
| OBServer node restart required for take effect | No. The setting takes effect immediately after it is configured. |
Considerations
If low-priority tasks run slowly, you can increase the value of this parameter. We recommend that you double the value each time.
Example
Set the number of threads to be used for DDL tasks in this tenant to 4.
obclient> ALTER SYSTEM SET ddl_thread_score = 4;