Which two statements are true about the PL/SQL initialization parameters? (Choose two.)
A.
To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than
or equal to l.
B.
The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for
better performance.
C.
Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for
computation-intensive procedural operations.
D.
Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units
that have already been compiled
B C
B, C
b,c
BC
B-C ok
BUT
why B says “the default value of 2” ? The default value is 0…
http://docs.oracle.com/cd/B12037_01/server.101/b10755/initparams163.htm
It has been changed in Oracle 11g:
Default value: 2.
Range of values: 0 to 3.
optimize_level=1: can remove unnecessary code
optimize_level=2: can move source code
BC