Note
This variable is introduced since OceanBase Database V4.2.2.
Purpose
ob_enable_pl_cache specifies whether to enable the PL cache module.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Boolean |
| Default value | 1 |
| Value range |
|
| Effective scope |
|
| Modifiable | Yes. You can use the SET statement to modify the variable. |
Considerations
We recommend that you enable the PL cache module. If you disable the module, stored procedure recompilation will be triggered each time a stored procedure is executed.
Examples
Set the variable at the session level as follows:
obclient> SET ob_enable_pl_cache=true;Set the variable at the global level as follows:
obclient> SET GLOBAL ob_enable_pl_cache=true;