Note
This parameter was removed in V4.2.3 BP1 and adjusted to the plsql_optimize_level (Global) system variable.
Description
The plsql_optimize_level parameter controls the optimization level during compilation of PL code.
Privilege requirements
- Query privilege Both the
SHOW PARAMETERSstatement and theGV$OB_PARAMETERSview are available to thesystenant and all user tenants. - Modify privilege Both the
systenant and user tenants can modify this parameter.
Attribute description
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default value | 1 |
| Value range | [0,3]
|
| Restart required | No |
Example
Enable optimization during compilation of PL code.
obclient> ALTER SYSTEM SET plsql_optimize_level=1;