Note
This parameter is removed starting from V4.2.3 BP1 and replaced with the system variable plsql_optimize_level (Global).
Description
plsql_optimize_level specifies the optimization level for PL code compilation.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query the value of this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and all user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 1 |
| Value range | [0,3]
|
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Enable optimization for PL code compilation.
obclient> ALTER SYSTEM SET plsql_optimize_level=1;