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 Oracle Banking Trade Finance 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.

E.g.: - exec dbms_utility.compile_schema('FCCBM2')

Here, ‘FCCBM2’ refers to the Oracle Banking Trade Finance schema.