Note
For V4.3.x, this parameter is available starting with V4.3.5 BP4.
Description
ob_deterministic_udf_cache_max_size specifies the maximum total memory size (in bytes) that can be used for caching all deterministic UDFs during statement execution.
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 | Capacity |
| Default value | 16M |
| Value range | [0,+∞)
NoteIf the value is 0, the execution-time 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
Run the following command to disable the execution-time cache feature.
obclient> ALTER SYSTEM SET ob_deterministic_udf_cache_max_size='0B';Run 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';