plsql_optimize_level

plsql_optimize_level specifies the optimization level for compiling PL/SQL code.

Privilege requirements

• Query variables

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

• Modify variables

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

Description

Usage notes

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

Examples

• MySQL-compatible mode

  • Set the PL optimization level to 1 globally to disable frontend optimization and enable backend optimization.

    obclient> SET GLOBAL plsql_optimize_level = 1;
    

  • Set the PL optimization level to 2 globally to enable frontend and backend optimization.

    obclient> SET GLOBAL plsql_optimize_level = 2;
    

• Oracle-compatible mode

  • Set the PL optimization level to 1 globally to disable frontend optimization and enable backend optimization.

    obclient> ALTER SYSTEM SET plsql_optimize_level = 1;
    

  • Set the PL optimization level to 2 globally to enable frontend and backend optimization.

    obclient> ALTER SYSTEM SET plsql_optimize_level = 2;