ob_enable_pl_cache

Description

ob_enable_pl_cache specifies whether to enable the PL cache module.

Privilege requirements

• Query variables

  • Global level

    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.

  • Session level

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

• Modify variables

  • Global level

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

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

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

  • Session level

    sys tenant and all user tenants can directly modify the value of a session system variable.

Attributes

Usage notes

We recommend that you enable this feature. If you disable the PL cache module, the stored procedure will be recompiled every time it is executed.

Examples

• Session level

  obclient> SET ob_enable_pl_cache=true;
  

• Global level

  obclient> SET GLOBAL ob_enable_pl_cache=true;