plsql_optimize_level

plsql_optimize_level specifies the optimization level for PL/SQL compilation.

Privilege requirements

• Query variables

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

• Modify variables

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

Description

Usage

The higher the optimization level, the more optimization operations the compiler will perform. We recommend that you set plsql_optimize_level to 2.

Examples

• MySQL mode

  • Set the PL optimization level to 1 globally to disable front-end optimization and enable back-end optimization.

    obclient> SET GLOBAL plsql_optimize_level = 1;
    

  • Set the PL optimization level to 2 globally to enable both front-end and back-end optimization.

    obclient> SET GLOBAL plsql_optimize_level = 2;
    

• Oracle mode

  • Set the PL optimization level to 1 globally to disable front-end optimization and enable back-end optimization.

    obclient> ALTER SYSTEM SET plsql_optimize_level = 1;
    

  • Set the PL optimization level to 2 globally to enable both front-end and back-end optimization.

    obclient> ALTER SYSTEM SET plsql_optimize_level = 2;