Overview
px_target_low_watermark specifies the percentage threshold for the low-watermark of the number of parallel threads. When the number of parallel threads exceeds this threshold, downgrading control is initiated for the degree of parallelism of newly scheduled DFO tasks to prevent CPU resource exhaustion.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
This parameter can be modified by both the
systenant and user tenants.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 60 |
| Value range | [0, 100] |
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
The value of the px_target_low_watermark parameter must satisfy the following relationship:
px_target_low_watermark <= px_target_high_watermark <= px_target_workers_per_cpu
Configuration example
Set the low-watermark percentage threshold for the number of parallel threads to 5.
obclient> ALTER SYSTEM SET px_target_low_watermark = 5;