Factors that you consider for compiling a PL/SQL program unit for interpreted mode.
Types of PL/SQL programs for which you consider setting the compilation method to native 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:
Post a Comment