1. Database Practices
  2. PLSQL Optimizer Level

5 PLSQL Optimizer Level

The plsql_optimize_level value for all the pl/sql units should be same which would be the value set in plsql_optimize_level init parameter.

Following sql gives the PLSQL optimizer level for FLEXCUBE schema plsql units:

Select PLSQL_OPTIMIZE_LEVEL,type,count(*) "Count" from
user_plsql_object_settings group by PLSQL_OPTIMIZE_LEVEL,type;

PLSQL_OPTIMIZE_LEVEL for all the objects should be same which should be value set in plsql_optimize_level init parameter. If there is a difference then the objects should be recompiled. This can be done using dbms_utility.compile_schema procedure.

Eg: - exec dbms_utility.compile_schema('FCCBM2')

Here, ‘FCCBM2’ refers to the FLEXCUBE schema.

Note:

The ‘dbms_utility.compile_schema’ procedure invalidates and recompiles all the plsql units.