ob_enable_pl_cache

Description

ob_enable_pl_cache specifies whether to enable the PL cache module.

Privilege requirements

• Query variables

  • Global level

    In both Oracle and MySQL modes, you can use the SHOW VARIABLES statement or 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 in the sys tenant and all user tenants.

  • Session level

    The sys tenant and all user tenants can use the SHOW VARIABLES statement or view SYS.TENANT_VIRTUAL_SESSION_VARIABLE (Oracle mode) or view information_schema.SESSION_VARIABLES (MySQL mode) to view the values of session system variables.

• Modify variables

  • Global level

    • The sys tenant has direct read/write access to the Global system variables.

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

    • An Oracle user tenant requires the ALTER SYSTEM privilege to modify the values of global system variables.

  • Session level

    The sys tenant and all user tenants can directly modify the values of the session system variables of their own tenants.

Attributes

Considerations

We recommend that you enable the PL cache module. If you disable the module, stored procedure recompilation will be triggered each time a stored procedure is executed.

Examples

• Session-level operation

  obclient> SET ob_enable_pl_cache=true;
  

• Global-level operation

  obclient> SET GLOBAL ob_enable_pl_cache=true;