Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

plsql_optimize_level Tips Oracle Tips by Burleson

Oracle 10g plsql_optimize_level

Parameter type – Integer

Default value – 2

Modifiable – ALTER SESSION, ALTER SYSTEM

Range of values – 1 | 2

• plsql_optimize_level – This specifies the optimization level that will be used to compile PL/SQL library units. The higher the setting of this parameter, the more effort the compiler makes to optimize PL/SQL library units.

Generally, setting this parameter to 2 pays off in better execution performance. Sometimes, however, the compiler runs slowly on a particular source module or optimization does not make sense for some reason (e.g., during rapid turnaround development). In such cases, setting this parameter to 1 will result in almost as optimal a compilation with less use of compile-time resources.

The value of this parameter is stored persistently with the library unit.