Note
This parameter is introduced in OceanBase Database V4.2.5 BP6.
Description
ob_deterministic_udf_cache_max_size specifies the maximum amount of memory (in bytes) that can be used by the cache pool for all deterministic user-defined functions (UDFs) during statement execution.
Privilege requirements
Querying the parameter
You can run the
SHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to query the value of this parameter in thesystenant and all user tenants.Modifying the parameter
You can modify this parameter in the
systenant and all user tenants.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Capacity |
| Default value | 16M |
| Value range | [0,+∞)
NoteIf the value is 0, the execution cache feature is disabled. |
| Modifiability | Yes. You can modify this parameter by using the ALTER SYSTEM SET statement. |
| Effective only after OBServer restart | No. This parameter takes effect immediately after the setting. |
Examples
Run the following command to disable the execution cache feature:
obclient> ALTER SYSTEM SET ob_deterministic_udf_cache_max_size='0B';Run the following command to set the maximum amount of memory that can be used by the cache pool for all
deterministicUDFs to 16M:obclient> ALTER SYSTEM SET ob_deterministic_udf_cache_max_size='16M';