plsql_optimize_level specifies whether to enable compilation optimization.
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 1 |
| Value range | 0: disable compilation optimization. 1: enable compilation optimization. |
| Effective upon OBServer node restart | No |
Here is an example:
obclient> ALTER SYSDATE SET plsql_optimize_level=1;