plsql_optimize_level

The plsql_optimize_level variable controls the optimization level during compilation of PL code.

Privilege requirements

• Query variables

  Users in the sys tenant and all users in user tenants can view the values of session system variables by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) and the information_schema.SESSION_VARIABLES view (MySQL mode).

• Modify variables

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

Feature 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;