plsql_optimize_level

The plsql_optimize_level variable controls the optimization level for PL code compilation.

Privilege requirements

• Query variables

  Tenants of the sys tenant and user tenants can query the session system variable's value by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or the information_schema.SESSION_VARIABLES view (MySQL mode).

• Modify variables

  Tenants of the sys tenant and user tenants can directly modify the session system variable's value in their own tenant.

Description

Suggestions

Higher optimization levels mean more optimizations are performed by the compiler. We recommend that you set the plsql_optimize_level variable to 2. If you want more information, see Examples.

Examples

• MySQL mode

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

    obclient> SET GLOBAL plsql_optimize_level = 1;
    

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

    obclient> SET GLOBAL plsql_optimize_level = 2;
    

• Oracle mode

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

    obclient> ALTER SYSTEM SET plsql_optimize_level = 1;
    

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

    obclient> ALTER SYSTEM SET plsql_optimize_level = 2;