Which two statements are true about the PL/SQL initialization parameters?

Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

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

Explanation:

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

samkelo siyabonga ngubo

samkelo siyabonga ngubo

B,C

Reply

Piero

Piero

B,C

http://psoug.org/reference/plsql_warnings.html

A is the opposite of the true……….

PLW-06014 PLSQL_OPTIMIZE_LEVEL <= 1 turns off native code generation
Native code generation was not done because the optimization was set to 1 or less.

D IS WRONG , IT AFFETES COMPILATIONS SINCE ALTERATION IS DONE, NOT BEFORE

Reply