Note
This parameter is removed starting with V4.2.3 BP1 and is adjusted to the system variable plsql_optimize_level (Global).
Description
plsql_optimize_level specifies the optimization level for PL code compilation.
Privilege requirements
Query the parameter
You can use the
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter in thesystenant and all user tenants.Modify the parameter
You can modify this parameter in the
systenant and all user tenants.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 1 |
| Value range |
|
| Effective upon OBServer node restart | No. |
Examples
Enable optimization for PL code compilation.
obclient> ALTER SYSTEM SET plsql_optimize_level=1;