Note
For V4.4.0, this parameter is available starting with V4.4.0.
Description
ob_deterministic_udf_cache_max_size specifies the maximum total memory size (in bytes) that can be used for the cache pool of all deterministic UDFs during statement execution.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 16M |
| Value range | [0,+∞)
NoteIf the value is 0, the execution cache feature is disabled. |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Execute the following command to disable the execution cache feature.
obclient> ALTER SYSTEM SET ob_deterministic_udf_cache_max_size='0B';Execute the following command to set the maximum total memory size of the cache pool to 16M.
obclient> ALTER SYSTEM SET ob_deterministic_udf_cache_max_size='16M';