Note
The feature corresponding to this parameter does not take effect. This parameter has been deprecated since OceanBase Database V4.2.0.
Description
plan_cache_low_watermark specifies the memory threshold to stop plan cache eviction. The eviction is stopped when the memory occupied by the plan cache decreases to the specified threshold.
Attributes
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 1500 MB. You must specify the unit. By default, MB is used. |
| Value range | [0, plan_cache_high_watermark) |
| 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. |