Search This Blog

Monday, January 06, 2014

Factors that you consider for compiling a PL/SQL program unit

Factors that you consider for compiling a PL/SQL program unit for interpreted mode.

  • A PL/SQL program which needs to be recompiled frequently
  • A PL/SQL program that spends most of the time executing SQL


Types of PL/SQL programs for which you consider setting the compilation method to native mode.

  • PL/SQL programs that have computation-intensive procedural operations
  • A PL/SQL program, which is called with the same parameters by multiple sessions


No comments: