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 of the
sysuser and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to obtain the value of 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 to use 2 threads by default. |
| Value range | [0, 100] |
| Modifiability | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| 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;