Note
- For OceanBase Database V4.3.x, this variable was introduced in OceanBase Database V4.3.1.
- For OceanBase Database V4.2.x, this variable was introduced in OceanBase Database V4.2.2.
Description
ob_enable_pl_cache specifies whether to enable the PL cache module.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | true |
| 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
obclient> SET ob_enable_pl_cache=true;Set the variable at the global level
obclient> SET GLOBAL ob_enable_pl_cache=true;