René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

PL/SQL related init params

PLSQL_CCFLAGS

New with Oracle 10g Release 2, used for conditional compilation.

PLSQL_CODE_TYPE

PLSQL_DEBUG

PLSQL_NATIVE_LIBRARY_DIR

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT

PLSQL_OPTIMIZE_LEVEL

This parameter is new with Oracle 10g.
It can be set to either 0, 1 or 2. Setting it to 2 means to apply more effort compiling pl/sql. This usually results in better performance executing pl/sql, but takes longer to compile.

PLSQL_WARNINGS