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
thanks. very clear explanation
Also think that correct answers are BC:
Not A:
https://docs.oracle.com/database/121/LNPLS/overview.htm#LNPLS0121
If the optimization level (set by PLSQL_OPTIMIZE_LEVEL) is less than 2:
The compiler generates interpreted code, regardless of PLSQL_CODE_TYPE.
If you specify NATIVE, the compiler warns you that NATIVE was ignored.
B:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams184.htm#REFRN10255
PLSQL_OPTIMIZE_LEVEL
Default value 2
“Applies a wide range of modern optimization techniques beyond those of level 1 including changes which may move source code relatively far from its original location.”
C:
https://docs.oracle.com/database/121/LNPLS/tuning.htm#LNPLS910
“PL/SQL native compilation provides the greatest performance gains for computation-intensive procedural operations. Examples are data warehouse applications and applications with extensive server-side transformations of data for display.”
Not D:
https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams159.htm#REFRN10253
“When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. “
Also think that correct answers are BC:
Not A:
https://docs.oracle.com/database/121/LNPLS/overview.htm#LNPLS0121
If the optimization level (set by PLSQL_OPTIMIZE_LEVEL) is less than 2:
The compiler generates interpreted code, regardless of PLSQL_CODE_TYPE.
If you specify NATIVE, the compiler warns you that NATIVE was ignored.
B:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams184.htm#REFRN10255
PLSQL_OPTIMIZE_LEVEL
Default value 2
“Applies a wide range of modern optimization techniques beyond those of level 1 including changes which may move source code relatively far from its original location.”
C:
https://docs.oracle.com/database/121/LNPLS/tuning.htm#LNPLS910
“PL/SQL native compilation provides the greatest performance gains for computation-intensive procedural operations. Examples are data warehouse applications and applications with extensive server-side transformations of data for display.”
Not D:
https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams159.htm#REFRN10253
“When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. “