Multiple choice technology databases

In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?

  1. It degrades the run time and compiler performance

  2. It provides better run time and compiler performance

  3. It provides better optimization of the statement during parse time.

  4. It forces the rule based optimizer to be used for statement optimization.

  5. It provides better run time performance, but slightly degraded compiler performance.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

PLSQL_OPTIMIZE_LEVEL=2 enables aggressive optimization that significantly improves runtime performance by applying more compilation time for optimization. This includes transformations like subprogram inlining and better code generation. Level 1 is for minimal optimization (faster compile), level 0 disables optimization. It does not force rule-based optimizer.

Keep practicing — related questions