Note
- This parameter was introduced in V4.2.5 for V4.2.x.
- This parameter was introduced in V4.3.5 for V4.3.x.
Description
The query_memory_limit_percentage parameter specifies the percentage of tenant memory that can be used by a single SQL statement. If the memory usage exceeds the specified threshold, the system returns an error and interrupts the execution of the SQL statement.
Privilege requirements
Query the parameter
The
systenant and all user tenants can execute theSHOW PARAMETERSstatement or viewGV$OB_PARAMETERSto query the parameter.Modify the parameter
The
systenant and user tenants can modify the parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 50 |
| Value range | [0, 100] |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The parameter takes effect immediately after it is set. |
Examples
Set the maximum memory that a single SQL statement can use to 50% of the tenant memory.
ALTER SYSTEM SET query_memory_limit_percentage = 50;