Note
This parameter is introduced in OceanBase Database V4.3.5 BP1.
Description
enable_adaptive_plan_cache specifies whether to enable adaptive plan cache.
Applicability
This parameter applies to OceanBase Database in MySQL mode and Oracle mode.
Privilege requirements
Querying the parameter
You can execute 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 only in the
systenant. User tenants cannot modify this parameter. / You can modify this parameter in both thesystenant and user tenants.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | BOOL |
| Default value | False |
| Value range | |
| Modifiability | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| Effective only after OBServer restart | No |
Considerations
After you enable the adaptive plan cache feature, the system automatically enables or disables the plan cache based on the SQL characteristics.
Examples
Run the following statement to enable the adaptive plan cache feature:
obclient> ALTER SYSTEM SET enable_adaptive_plan_cache = true;