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

  sys 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 Global system variables.

• Modify variables

  • sys tenants can directly modify the value of Global system variables.

  • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the value of Global system variables.

  • Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of Global system variables.

Attributes

Usage notes

The maximum amount of memory that can be used for the plan cache is equal to the tenant memory limit multiplied by the value of ob_plan_cache_percentage divided by 100. For more information about the maximum memory limit, see ob_plan_cache_percentage.

Examples

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

obclient> SET GLOBAL ob_plan_cache_percentage =5;