4 PLSQL Optimizer Level

The plsql_optimize_level value for all the PLSQL units should be the same, which would be the value set in the plsql_optimize_level init parameter.

Following SQL provides the PLSQL optimizer level for 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 the same as the value set in plsql_optimize_level init parameter. If there is a difference, then the objects should be recompiled. It can be done using dbms_utility.compile_schema procedure.

Note:

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

For example:

exec dbms_utility.compile_schema('FCCBM2')

Here, FCCBM2 refers to the schema.