Oracle Error PLW-06014: PLSQL_OPTIMIZE_LEVEL <= 1 turns off native code generation

Oracle Error Message

PLW-06014: PLSQL_OPTIMIZE_LEVEL

Reason for the Error

Native code generation was not done because the optimization was set to 1 or less.

Solution

The goal of native code generation is high performance and a low optimization level defeats that purpose. Either request a higher optimization level or remove the request for native code generation. Note that using the deprecated parameter PLSQL_DEBUG also forces the optimization level to 1; do not use this parameter when native code generation is desired.