Note:This parameter is deprecated in favor of the
PLSQL_DEBUGparameters. Oracle recommends that you use
PLSQL_COMPILER_FLAGSis retained for backward compatibility only.
PLSQL_COMPILER_FLAGS specifies a list of flags for the PL/SQL compiler as a comma-separated list of strings.
PL/SQL library units will be compiled to PL/SQL bytecode format. Such modules are executed by the PL/SQL interpreter engine.
PL/SQL library units (with the possible exception of top-level anonymous PL/SQL blocks) will be compiled to native (machine) code. Such modules will be executed natively without incurring any interpreter overhead.
PL/SQL library units will be compiled for debugging
PL/SQL library units will be compiled for normal execution
The following combinations of flags are invalid specifications for the
When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. The value of this parameter is stored persistently with the library unit. If a PL/SQL library unit is compiled native, all subsequent automatic recompilations of that library unit will use native compilation.