ob_plan_cache_percentage

Description

ob_plan_cache_percentage specifies the percentage of memory that can be used for the plan cache.

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-compatible mode) or the information_schema.GLOBAL_VARIABLES view (MySQL-compatible mode) to view the value of global system variables.

• Modify variables

  • The sys tenant can directly modify the value of global system variables.

  • A MySQL user tenant must have the SUPER or ALTER SYSTEM privilege to modify the value of global system variables.

  • An Oracle user tenant must have the ALTER SYSTEM privilege to modify the value of global system variables.

Attributes

Usage notes

The maximum memory that can be used for the plan cache = tenant memory limit * ob_plan_cache_percentage/100.

Examples

Set the percentage of memory that can be used for the plan cache to 5.

obclient> SET GLOBAL ob_plan_cache_percentage =5;