Note
This parameter was removed in V4.2.3 BP1 and replaced with the system variable plsql_optimize_level (Global).
Description
The plsql_optimize_level parameter controls the optimization level during compilation of PL code.
Privilege requirements
- Query privilege Both the
systenant and user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter. - Modify privilege Both the
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Int |
| Default value | 1 |
| Value range | [0,3]
|
| Restart OBServer node required | No |
Example
Set optimization to be enabled during compilation of PL code.
obclient> ALTER SYSTEM SET plsql_optimize_level=1;