ob_plan_cache_evict_low_percentage

Description

ob_plan_cache_evict_low_percentage specifies the percentage of the maximum memory size that is used to stop evicting plan cache.

Privilege requirements

• Query variables

  sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or the information_schema.GLOBAL_VARIABLES view (MySQL mode) to view the value of a global system variable.

• Modify variables

  • sys tenant can modify the value of a global system variable.

  • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the value of a global system variable.

  • Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of a global system variable.

Attributes

Usage notes

The size of memory used to stop evicting plan cache (low watermark of plan evict) = absolute value of maximum memory size × ob_plan_cache_evict_low_percentage / 100. For more information about the absolute value of the maximum memory size, see ob_plan_cache_percentage.

Examples

Set the percentage of the maximum memory size that is used to stop evicting plan cache to 50.

obclient> SET GLOBAL ob_plan_cache_evict_low_percentage =50;