ob_plan_cache_evict_high_percentage

Description

ob_plan_cache_evict_high_percentage specifies the percentage of the memory size that triggers plan cache eviction relative to the absolute value of the maximum memory size.

Privilege requirements

• Query variables

  The 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 values of Global system variables.

• Modify variables

  • The sys tenant can directly modify the value of a Global system variable.

  • A MySQL user tenant must have the SUPER or ALTER SYSTEM privilege to modify the value of a Global system variable.

  • An Oracle user tenant must have the ALTER SYSTEM privilege to modify the value of a Global system variable.

Attributes

Usage notes

The memory size that triggers plan cache eviction (high watermark) = absolute value of the maximum memory size of the plan cache × ob_plan_cache_evict_high_percentage / 100. For more information about the absolute value of the maximum memory size of the plan cache, see ob_plan_cache_percentage.

Examples

Set the percentage of the memory size that triggers plan cache eviction relative to the absolute value of the maximum memory size to 90.

obclient> SET GLOBAL ob_plan_cache_evict_high_percentage =90;