Note
This parameter is introduced since OceanBase Database V3.2.1.
Description
job_queue_processes specifies the maximum number of concurrent tasks that can be run under each tenant. You can set this parameter to prevent tenant resources from being excessively occupied by tasks.
Applicability
This parameter only applies to the Oracle mode of OceanBase Database.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 1000 |
| Value range | [0, 16384]
Note
|
| Modifiable | Yes. You can modify it by using the ALTER SYSTEM SET statement. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Set the maximum number of concurrent tasks that can be run in a tenant to 1000.
obclient> ALTER SYSTEM SET job_queue_processes=1000;