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_high_watermark specifies the memory threshold to trigger plan cache eviction. Automatic eviction is triggered when the memory occupied by the plan cache reaches the specified threshold.
Attributes
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 2000 MB. You must specify the unit. By default, MB is used. |
| Value range | [0, +∞) |
| 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. |