Search notes:

Oracle: init parameter PLSQL_OPTIMIZE_LEVEL

The value of the init parameter plsql_optimize_level constrols how much effort the PL/SQL compiler invests into optimizing PL/SQL code. This level can be set to a value between 1 and 3. The default is 2.

Inlining code

Setting plsql_optimize_level to 3 causes the compiler to seek oportunities to inline code.
Code can be forced to be inlined with the inline pragma.

See also

ALL_PLSQL_OBJECT_SETTINGS
init parameters

Index