plsql_optimize_level

Description

plsql_optimize_level specifies the optimization level when PL/SQL code is compiled.

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 mode) or the information_schema.SESSION_VARIABLES view (MySQL 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 in their own tenants.

Description

Considerations

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

Examples

• MySQL 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 optimizations.

    obclient> SET GLOBAL plsql_optimize_level = 2;
    

• Oracle 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 optimizations.

    obclient> ALTER SYSTEM SET plsql_optimize_level = 2;