PLSQL_OPTIMIZE_LEVEL
This attribute specifies the optimization level to 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. Possible values are 0, 1, 2, or 3.
The PLSQL_OPTIMIZE_LEVEL connection attribute determines the
initial value of this attribute within a session. The value can be modified by an
ALTER
SESSION statement, described in Oracle TimesTen In-Memory Database SQL
Reference. For example:
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL = 2;
Required Privilege
No privilege is required to change the value of this attribute.
Setting
Set PLSQL_OPTIMIZE_LEVEL as follows:
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems |
|
The default value is |
|
Windows ODBC Data Source Administrator |
Not applicable |