Note
This parameter was introduced in V1.4.
Description
The large_query_threshold parameter specifies the threshold for query execution time. Requests that exceed the threshold may be suspended. Suspended requests are automatically classified as large queries and scheduled according to the large query scheduling strategy.
Privilege requirements
Query the parameter
sysand all user tenants can query thelarge_query_thresholdparameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
Only
systenants can modify thelarge_query_thresholdparameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 5s |
| Valid values | [0ms, +∞)
NoteIn V4.3.x, the valid value range was changed from [1ms, +∞) to [0ms, +∞) starting from V4.3.0. |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Example
Set the threshold for query execution time to 5s.
obclient> ALTER SYSTEM SET large_query_threshold = '5s';